|
马上注册,结交更多好友,享用更多功能,让你轻松玩转社区。
您需要 登录 才可以下载或查看,没有帐号?立即注册
x
Access是一种桌面数据库,只适合数据量少的应用,在处理少量数据和单机访问的数据库时是很好的,效率也很高。但是它的同时访问客户端不能多于4个。access数据库有一定的极限,如果数据达到100M左右,很容易造成服务器iis假死,或者消耗掉服务器的内存导致服务器崩溃。ChrisPayne
September11,2000
Sonowyouvegotyourselfaprettyfunctionalauction.Letstalkabitaboutwhatwehaventcovered,
andafewmiscellaneousthings.
ThingstoAdd
Whilethisauctionwillwork,itlacksafewfeaturesoffinerproducts.Forinstance,youcouldhave
builtina"takeless"option-if,forexample,auserbidsfor10items,butiswillingtotakelessif
necessary,thenthiscouldbeaccommodated.Itwouldrequireaddingabooleanfieldtothedatabase,anda
fewmodificationstotheResolveBids()code.Youshouldalsogivethesellertheoptionto"nottake
less,"meaningthatifalltheitemshaventbeenbidfor,thenthewholethingisoff.
Anotheroptioncouldbeadding"deeperlots."Thisallowssellerstospecifythattheyhavemultiplelots
thattheymustselltogether-forinstance,5TVsand5VCRs.Thesecouldallgoinonelot,butby
separatingthemintomultiplelotsthataresoldtogether,youareofferingthesellerandbuyersan
advantage(bothpricewiseandcompetiveness-wise).
Mostauctionsalsoallow"reserveprices."Thisisapricethesellerspecifiesthatmustbemetbefore
anyitemscanbesold.Forexample,Iwanttosellacar,butIwonttakelessthan$5000.Thisisabit
differentthantheminimumacceptablebid,inthatthelatterissetlowtoencouragebuyerstoplace
bids,whiletheformerensuresIdontendupsellingmy$5000carfor$2-sellerprotection.
Afullyfunctionalauctionshouldalsohavemorerobustalertingmechanisms.Ihaventbuiltinherethe
abilitytonotifyuserswhentheyhavebeenoutbid.(Makesurethough,thatifyoudobuildthis
functionality,youdontsendanalerteverytimetheproxyengineplacesabid-theuserwouldget
floodedwithtonsofemailsthatarentnecessary.Rather,justsendanalertwhenthepriceforanitem
growslargerthanthemaximumbidthebuyerspecified,togivethemanotherchanceattheitem.)
Finally,youllneedmorefunctionalitythanjustthefunctionsIspecifiedhere.Youmightwanttocreate
anadmininterfacethatallowsanadminstratortoviewallbids,users,andauctions,deletespecified
items,modifythem,etc.Andyoullneedtobuildthevisualfrontend-somethingsothatbuyersand
sellerscanbidforandenteritemstosell,andviewthecurrentstatusofanauction(thecurrent
winningbid,thenumberofitemssold,etc).Youmayalsowishto"beefup"thetablesspecifiedhere,to
allowuserstoenterinmorespecificinformation(i.e.aSKUnumber,aURL,etc).
CodingPractices
YoumayhavenoticedIspecifiedtheconnectionstringandcreatedarecordsetobjectineveryfunction.
Whilethiswasdoneforclarityinthisarticle,amoreefficientmethodwouldbetospecifyaglobalor
sessionvariablesomewhereelse-forinstanceintheglobal.asafile,oranincludefilethatisincluded
oneverysinglepage.
Also,thistypeoffunctionalitywouldbestbewrappedupinaCOMobject.Thiswouldenhancespeedand
increasesecurity.DoallthetestingintheASPfirstthough!
当然了,现在国内CRM厂商的产品与其说是CRM,但从至少从我的角度分析上来看,充其量只是一个大型的进销存而已了,了解尚浅,不够胆详评,这里只提技术问题 |
|