Re: showcart is slow

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 18044
interpreted = N
texte = >I am doing an internal store for my company's products which will be done >in Japanese. In comparing it to my store that is in English, the showcart >and add commands are about twice as slow. > >I figure that since the database is much bigger on the internal store, that >might be the cause but searches and other commands are just as fast.ShowCart does a lot of lookups into your database when displaying fields inside a [LineItems] loop, and we sped up a lot of that for 2.1.2. It can be slow if you have lots of separate [OrderFile] contexts on a page, or anything else out of the standard GeneralStore flow. We may have to look at your WebDNA to see if there's something to do to speed it up.www.musicianstore.com has over 200,000 products, and we tuned ShowCart for performance under those conditions.Technical Support | ==== eCommerce and Beyond ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: showcart is slow (PCS Technical Support 1998)
  2. Re: showcart is slow (Kenneth Grome 1998)
  3. showcart is slow (Kevin Furuta 1998)
>I am doing an internal store for my company's products which will be done >in Japanese. In comparing it to my store that is in English, the showcart >and add commands are about twice as slow. > >I figure that since the database is much bigger on the internal store, that >might be the cause but searches and other commands are just as fast.ShowCart does a lot of lookups into your database when displaying fields inside a [lineitems] loop, and we sped up a lot of that for 2.1.2. It can be slow if you have lots of separate [orderfile] contexts on a page, or anything else out of the standard GeneralStore flow. We may have to look at your WebDNA to see if there's something to do to speed it up.www.musicianstore.com has over 200,000 products, and we tuned ShowCart for performance under those conditions.Technical Support | ==== eCommerce and Beyond ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/ PCS Technical Support

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:

[GROUPS] followup (1997) Web Catalog 2 demo (1997) Price problem (1997) [ConvertChars] problem (1997) RE: Remote administration (1998) [isfile] ? (1997) forms and variables (1998) FW: About that math question ... (2003) Archive (Zip, Sit, Tgz) (2004) webcat running as www, should that be webstar for use with webstar? (2002) Search Engine questions ... (2002) Field name-subcategory (1997) [TaxTotal] (1998) Online reference (1997) New public beta available (1997) no global [username] or [password] displayed ... (1997) Replace context problem ... (1997) Error Lob.db records error message not name (1997) Auto Unsubscribe (2000) redirect with frames (1997)