Re: How do I make this faster????
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 28880
interpreted = N
texte = Dedicate a 6100 to the task? Aaron Lynch has the same issue with the MLS database as it's around 26,000 records and searching through all of them and replacing them takes a good 5 minutes. Our solution will be to just dedicate a older box. Jesse Proudman - NineWire Productions http://www.ninewire.com <-> jesse@ninewire.com Innovative and Creative Web Design and Hosting> -----Original Message----- > From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On > Behalf Of Joseph D'Andrea > Sent: Friday, March 10, 2000 2:23 PM > To: WebCatalog Talk > Subject: How do I make this faster???? > > > I have a database which is currently 16,000 records in size for a > total disk space of ~6MB. I need to build a datafile of the e-mail > addresses contained in the database. Currently, extracting just 500 > records takes 36 seconds on a slow G3. I understand that speed is > relative to the processor.... When I it this template from a browser > it take close to 40 seconds to complete and all this time the server > (WebSTAR) appears to be deaf to other connections. > > How can I make this execute faster or friendlier especially > considering that the real application will need at least one other > search argument and the database will do nothing but grow in terms of > number of records. > > [math show=f]count=0[/math] > [delete db=test.db&neDBEMAILdata=_delete_all] > [search db=XXXXXXXX.db&neSKUdatarq=_find_all_&max=500] > [numfound] records found.
> [founditems] > [math show=f]count=[count]+1[/math] > [append db=test.db]dbemail=[url][email] ([MemberName])[/url][/append] > [/founditems] > [/search] > [count] records mailed. > > Thanks, > ___Joe___ > _________________________________________________ > Joseph D'Andrea JoeDan@West21.com > WEST21.com Internet services for the 21st Century > http://www.west21.com/ > _________________________________________________ > > > ------------------------------------------------------------- > 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 > > ------------------------------------------------------------- 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
Associated Messages, from the most recent to the oldest:
Dedicate a 6100 to the task? Aaron Lynch has the same issue with the MLS database as it's around 26,000 records and searching through all of them and replacing them takes a good 5 minutes. Our solution will be to just dedicate a older box. Jesse Proudman - NineWire Productions http://www.ninewire.com <-> jesse@ninewire.com Innovative and Creative Web Design and Hosting> -----Original Message----- > From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On > Behalf Of Joseph D'Andrea > Sent: Friday, March 10, 2000 2:23 PM > To: WebCatalog Talk > Subject: How do I make this faster???? > > > I have a database which is currently 16,000 records in size for a > total disk space of ~6MB. I need to build a datafile of the e-mail > addresses contained in the database. Currently, extracting just 500 > records takes 36 seconds on a slow G3. I understand that speed is > relative to the processor.... When I it this template from a browser > it take close to 40 seconds to complete and all this time the server > (WebSTAR) appears to be deaf to other connections. > > How can I make this execute faster or friendlier especially > considering that the real application will need at least one other > search argument and the database will do nothing but grow in terms of > number of records. > > [math show=f]count=0[/math] > [delete db=test.db&neDBEMAILdata=_delete_all] > [search db=XXXXXXXX.db&neSKUdatarq=_find_all_&max=500] > [numfound] records found.
> [founditems] > [math show=f]count=[count]+1[/math] > [append db=test.db]dbemail=[url][email] ([MemberName])[/url][/append] > [/founditems] > [/search] > [count] records mailed. > > Thanks, > ___Joe___ > _________________________________________________ > Joseph D'Andrea JoeDan@West21.com > WEST21.com Internet services for the 21st Century > http://www.west21.com/ > _________________________________________________ > > > ------------------------------------------------------------- > 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 > > ------------------------------------------------------------- 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
Jesse Proudman
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:
Not much on today :( (2004)
Duplicate Messages (1998)
Running _every_ page through WebCat ? (1997)
All choices on IE different than Netscape (1997)
Interfacing WebMerchant to www.fedex.com (1997)
[OT] Colored source code in IE? (2007)
[protect problem] (2004)
WebCat2b13MacPlugIn - syntax to convert date (1997)
Unsibscribe Was: UPS uber integration (2007)
locking variables? (2000)
Sample Tearoom Search Error (1998)
Append - form based command (1999)
WebDNA-Talk Digests (1997)
shipCost (1998)
WC2b15 File Corruption (1997)
Grep question [parsing variables] problem (2003)
Me know logical no need (2002)
emailer error -108 (1997)
Date stamp and purging (1998)
[WebDNA] php -> WebDNA: Can I do this with [tcpconnect]? (2013)