Re: How do I make this faster????
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 28881
interpreted = N
texte = >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. I can't be sure but I would think that using a [writefile] would be faster than trying to append 16000 files to a database. And why do you need the [count] variable? Would that ever be different than [numfound]? If not it is just wasting time.When using [writefile] you just have to [unurl] your tabs and returns to separate your fields and records. Sam Lewis, V.P. TechnologyTehabi Books http://www.tehabi.com/ 1201 Camino Del Mar, Suite 100, Del Mar, CA 92014 Tel: 626-852-0956 Fax: 916-404-5698 mailto:Sam@tehabi.comGet FREE Electronic Postcards at http://www.tehabi.com/postcards/------------------------------------------------------------- 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:
>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. I can't be sure but I would think that using a [writefile] would be faster than trying to append 16000 files to a database. And why do you need the [count] variable? Would that ever be different than [numfound]? If not it is just wasting time.When using [writefile] you just have to [unurl] your tabs and returns to separate your fields and records. Sam Lewis, V.P. TechnologyTehabi Books http://www.tehabi.com/ 1201 Camino Del Mar, Suite 100, Del Mar, CA 92014 Tel: 626-852-0956 Fax: 916-404-5698 mailto:Sam@tehabi.comGet FREE Electronic Postcards at http://www.tehabi.com/postcards/------------------------------------------------------------- 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
Sam Lewis
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:
Applying discounts as more items are added... (1997)
[BULK] [WebDNA] A new commerce system for v7+ (2011)
Three new problems, maybe a fourth (1997)
[format xs] freeze (1997)
[WebDNA] math variables bug in OSX 7.0 / 7.1 (2012)
FTP (1999)
RAM variables (1997)
Email Format (1998)
Req: Array Tags Explained, simple and clear (2004)
Error: the 'showcart' command requires that you specify a db (1997)
date pref (1999)
Multiple Currencies (2002)
A multi-processor savvy WebCatalog? (1997)
Date Formats (1997)
Another question (1997)
RE: Template Not Found (1998)
blank orders (2001)
How true is this? (1999)
WebDNA Solutions ... sorry! (1997)
shipcost (1997)