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 Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4720 Boston Way Lanham, MD 20706 301-459-3366 x.5010 fax 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:

    
  1. Re: attn: smitmicro - cart limitation (Velma Kahn 2002)
  2. Re: attn: smitmicro - cart limitation (NovaDerm Skincare Science 2002)
  3. Re: attn: smitmicro - cart limitation (Kalin Mintchev 2002)
  4. Re: attn: smitmicro - cart limitation (Stuart Tremain 2002)
  5. Re: attn: smitmicro - cart limitation (Alain Russell 2002)
  6. Re: attn: smitmicro - cart limitation (Rob Marquardt 2002)
  7. Re: attn: smitmicro - cart limitation (NovaDerm Skincare Science 2002)
  8. Re: attn: smitmicro - cart limitation (Donovan Brooke 2002)
  9. Re: attn: smitmicro - cart limitation (NovaDerm Skincare Science 2002)
  10. Re: attn: smitmicro - cart limitation (John Peacock 2002)
  11. Re: attn: smitmicro - cart limitation (Stuart Tremain 2002)
  12. Re: attn: smitmicro - cart limitation (Bob Minor 2002)
  13. Re: attn: smitmicro - cart limitation (Alain Russell 2002)
  14. Re: attn: smitmicro - cart limitation (Alain Russell 2002)
  15. Re: attn: smitmicro - cart limitation (Stuart Tremain 2002)
  16. Re: attn: smitmicro - cart limitation (Andrew Simpson 2002)
  17. Re: attn: smitmicro - cart limitation (Stuart Tremain 2002)
  18. Re: attn: smitmicro - cart limitation (Alain Russell 2002)
  19. Re: attn: smitmicro - cart limitation (Stuart Tremain 2002)
  20. Re: attn: smitmicro - cart limitation (Alain Russell 2002)
  21. Re: attn: smitmicro - cart limitation (Kenneth Grome 2002)
  22. Re: attn: smitmicro - cart limitation (Stuart Tremain 2002)
  23. Re: attn: smitmicro - cart limitation (Scott Anderson 2002)
  24. Re: attn: smitmicro - cart limitation (Kenneth Grome 2002)
  25. Re: attn: smitmicro - cart limitation (Development 2002)
  26. Re: attn: smitmicro - cart limitation (Scott Anderson 2002)
  27. Re: attn: smitmicro - cart limitation (Kenneth Grome 2002)
  28. Re: attn: smitmicro - cart limitation (Kalin Mintchev 2002)
  29. Re: attn: smitmicro - cart limitation (Phillip Bonesteele 2002)
  30. Re: attn: smitmicro - cart limitation (Kalin Mintchev 2002)
  31. Re: attn: smitmicro - cart limitation (dale's stuff 2002)
  32. Re: attn: smitmicro - cart limitation (Phillip Bonesteele 2002)
  33. Re: attn: smitmicro - cart limitation (Charles Kline 2002)
  34. attn: smitmicro - cart limitation (Kalin Mintchev 2002)
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 Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4720 Boston Way Lanham, MD 20706 301-459-3366 x.5010 fax 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)