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:
Weird bug, or is there something amiss? (1997)
Searching Multiple DBs (1997)
What am I doing wrong? (2000)
Modifying order output (1997)
WebCat2b13MacPlugIn - [shownext method=post] ??? (1997)
wc 2 pro users - sites, quotes wanted (1997)
[math] storage of variables (1997)
WebCatalog Prefs.ref file ? (1998)
Webstar 1.3.1 PPC (1997)
WebDNA & HTML Problems (2003)
problem: mail changed (1997)
Verifying both name and password (was: THANKS) (1997)
Database (2002)
RE: E-mailer error codes (1997)
required fields (1999)
Suffix Mapping (1998)
Renaming DB fields (2000)
RE: [sendmail]- bcc? (1998)
WebDNAReference (2000)
Big Databases (1997)