How do I make this faster????
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 28878
interpreted = N
texte = 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.comWEST21.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
Associated Messages, from the most recent to the oldest:
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.comWEST21.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
Joseph D'Andrea
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:
PCS Frames (1997)
Show if time tags (1997)
No Wanna Duppys (1998)
Viewing old carts (was FEW QUESTIONS) (1997)
Storebuilder Seems to have just died (2003)
Reminder... (2003)
encryption madness (2003)
WebMerchant Only reads 1.4 order files error (1997)
Some Advise needed (1997)
MacAuthorize and WebMerchant (1997)
Need help with emailer- 2 issues (1997)
Limit to Field Length in DB (1998)
Re:Emailer and encryption (1997)
Where's Cart Created ? (1997)
WebCat2b12 - nesting [tags] (1997)
limit to listwords (2001)
Dual 2GHz G5 (2003)
Re:trouble (1997)
PCS Frames (1997)
WebCat2: Items xx to xx shown, etc. (1997)