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:
Robert Minor duplicate mail (1997)
Apple event reply error (-1) (1997)
Unexpected comparison behavior change in 4.5.1 (2003)
Check boxes (1997)
Another Large Database Questions (1997)
Cancel Subscription (1996)
Plugin or CGI or both (1997)
Summing fields (1997)
can webcat create directories on NT? (1997)
Webmerchant/Cybercash (2000)
calculating tax rates, mail order solutions and version 2 (1997)
[WebDNA] SMTP via gmail is NOT POSSIBLE (2013)
WebDNA - MySQL - PHP (2003)
Got WebCat buyer's remorse? (1998)
Ticks Email Preference (2002)
unable to launch acgi in WebCat (1997)
more on quicktime test stuff (1997)
Installation webCatalog (French speakers please help) (1998)
[WebDNA] webDNA and JSON (2011)
WebDNA and FTP (2003)