Re: attn: smitmicro - cart limitation
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 44388
interpreted = N
texte = Stuart Tremain wrote:> We deal with some very complex ordering systems, we need to collect 175 > fields of information from each customer to complete their order. My condolences and my pity goes out to your customers! ;~)> Currently we use all 40 headers with delimeters to hold the data and > then split the headers to get the data our again.The basic fact of life is that the cart is a file, which is written to the disk every time you change it (potentially on each page). This can be enormous overhead, compared to a RAM resident database which is flushed intelligently.> > Our carts are never destroyed, all carts are held for various reasons. > If we keep all the order data in one place life is easier than spreading > it around.The very same argument can be made for keeping all of the order data in a single database, rather than in individual files. It would be even better if you stored the order data in a SQL database (as opposed to WebCat), since it's very unlikely that you would ever need to search through all of the fields on a regular basis. Additionally, with individual cart files, it is very difficult to do _any_ querying, whereas a database would allow you to perform sophisticated data mining.> > Things would be simpler if we could just add a few more headers :)TMTOWTDIJohn-- John PeacockDirector of Information Research and TechnologyRowman & Littlefield Publishing Group4720 Boston WayLanham, MD 20706301-459-3366 x.5010fax 301-429-5747-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list
.To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Stuart Tremain wrote:> We deal with some very complex ordering systems, we need to collect 175 > fields of information from each customer to complete their order. My condolences and my pity goes out to your customers! ;~)> Currently we use all 40 headers with delimeters to hold the data and > then split the headers to get the data our again.The basic fact of life is that the cart is a file, which is written to the disk every time you change it (potentially on each page). This can be enormous overhead, compared to a RAM resident database which is flushed intelligently.> > Our carts are never destroyed, all carts are held for various reasons. > If we keep all the order data in one place life is easier than spreading > it around.The very same argument can be made for keeping all of the order data in a single database, rather than in individual files. It would be even better if you stored the order data in a SQL database (as opposed to WebCat), since it's very unlikely that you would ever need to search through all of the fields on a regular basis. Additionally, with individual cart files, it is very difficult to do _any_ querying, whereas a database would allow you to perform sophisticated data mining.> > Things would be simpler if we could just add a few more headers :)TMTOWTDIJohn-- John PeacockDirector of Information Research and TechnologyRowman & Littlefield Publishing Group4720 Boston WayLanham, MD 20706301-459-3366 x.5010fax 301-429-5747-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
John Peacock
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
Creating comums (1998)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
problems with 2 tags shakur (1997)
WebDNA vars parsed in FLASH (ActionScript) (2004)
file uploads with webcat...binary? (1998)
[ShowNext] (1997)
OPEN MARKET PATENTS SOUND ECOMMERCE ALARM (1998)
[isfile] ? (1997)
resorting found set (2005)
A question on sub-categories (1997)
ConvertChars (2000)
WebMerch/Emailer Error (1998)
[REFERRER] AND Truncation (1998)
[WebDNA] WebDNA slow processing - conclusion (2011)
Preserving form data (1999)
WebCat2b13MacPlugIn - More limits on [include] (1997)
Authenticate (1997)
memory leaks (2005)
SMSI: databases corrupted on crash and permission issueson OSX (2002)
this works sometimes and sometimes not (1997)