Re: [search][founditems][orderfile]
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 51956
interpreted = N
texte = Doesn't the current version of webmerchant already store orders in the header.db and lineitems.db? If so, why don't you search these db's instead of opening individual order files? >Hello, > >I am wondering what others think about this (skeleton of course).. > >[search db] > [founditems] > [orderfile file=path/[o_file_from_db]] > [name],[company] > [/orderfile] > [/founditems] >[/search] > >For some reason, I am getting very slow results with one >found orderfile... even slower with two found items etc.. > >I am opening the orderfile and grabbing a couple things >from it. I realized that accessing the HD was going to >be slow but with only one orderfile It is approx. a 30 sec >wait... with two, It is about a minute etc.. > >Is this just a bad coding technique? > >More specifically, is there different engine methods involed >in using "file=" rather than "cart=" (such as ram resident cart info >compared to hard drive accessed cart info)??? > >I can actually probably code in a way where I don't have to >open each found orderfile, (by saving some info the db) but >I am curious to what others have found. > >Maybe my drives are slow (am waiting to hear back from the systems >person). > >Thanks, >Donovan > > >-- > =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o > DONOVAN D. BROOKE > Eucalyptus Design > Developer / Consultant > <-Web Development (specializing in eCommerce), -> > <-Graphic Design, and Pre-Press Consultation -> > > ADDRESS:> Donovan Brooke > DBA Eucalyptus Design > P.O. Box 260153 > Madison, WI 53726-0153 > > PH:> 1.608.442.5217 > email:> dbrooke@euca.us > Web:> http://www.euca.us > =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o > > >------------------------------------------------------------- >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://webdna.smithmicro.com/ -- Sincerely, Kenneth Grome ------------------------------------------------------------- Outsource your WebDNA programming for $18 an hour or less! ------------------------------------------------------------- ------------------------------------------------------------- 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://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Doesn't the current version of webmerchant already store orders in the header.db and lineitems.db? If so, why don't you search these db's instead of opening individual order files? >Hello, > >I am wondering what others think about this (skeleton of course).. > >[search db] > [founditems] > [orderfile file=path/[o_file_from_db]] > [name],[company] > [/orderfile] > [/founditems] >[/search] > >For some reason, I am getting very slow results with one >found orderfile... even slower with two found items etc.. > >I am opening the orderfile and grabbing a couple things >from it. I realized that accessing the HD was going to >be slow but with only one orderfile It is approx. a 30 sec >wait... with two, It is about a minute etc.. > >Is this just a bad coding technique? > >More specifically, is there different engine methods involed >in using "file=" rather than "cart=" (such as ram resident cart info >compared to hard drive accessed cart info)??? > >I can actually probably code in a way where I don't have to >open each found orderfile, (by saving some info the db) but >I am curious to what others have found. > >Maybe my drives are slow (am waiting to hear back from the systems >person). > >Thanks, >Donovan > > >-- > =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o > DONOVAN D. BROOKE > Eucalyptus Design > Developer / Consultant > <-Web Development (specializing in eCommerce), -> > <-Graphic Design, and Pre-Press Consultation -> > > ADDRESS:> Donovan Brooke > DBA Eucalyptus Design > P.O. Box 260153 > Madison, WI 53726-0153 > > PH:> 1.608.442.5217 > email:> dbrooke@euca.us > Web:> http://www.euca.us > =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o > > >------------------------------------------------------------- >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://webdna.smithmicro.com/ -- Sincerely, Kenneth Grome ------------------------------------------------------------- Outsource your WebDNA programming for $18 an hour or less! ------------------------------------------------------------- ------------------------------------------------------------- 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://webdna.smithmicro.com/
Kenneth Grome
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:
Stats (2001)
[WebDNA] Apple nixes Mac OS Server ("websites") and other (2018)
Orders to FMPro (2005)
webcat pro (1998)
Poll security (2004)
WebCat b13 CGI -shownext- (1997)
WebCat2b13 Command Reference Doc error (1997)
Delete only one duplicate record? (2003)
CORR: date format (2000)
WebCatalog can't find database (1997)
Serving images from databases (1998)
EIMS Problems (1997)
Re:Running 2 two WebCatalog.acgi's (1996)
How to include weather (2000)
Cart Creation (2003)
WebCat2 - storing unformatted date data? (1997)
[WebDNA] Limits? (2009)
Dubble Sku's in a Database (1999)
[SearchString] problem with [search] context (1997)
auction system w/ Web Cat (1999)