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:
Frames and WebCat (1997)
Shopping Cart Problems (2000)
Repeating Fields (1997)
Is there an alternative to emailer? (1999)
[WebDNA] Wishlist: ignore whitespace in database changes (2016)
credit card (1997)
Include Troubles (1998)
Nesting format tags (1997)
Bad Cookie / Internet Option / Internet Explorer (2004)
Upload Plugin (1998)
adding second sku (2000)
[WebDNA] Search on a database (2012)
[convertChars] and HTML Tags (1997)
WebCat and PDF (2000)
WebCatalog NT beta 18 now available (1997)
Attention all list readers (1997)
Emailer choke (1997)
Keep away (1997)
Scoping rules in WebDNA 4.0 (2000)
Attn: Bug in GeneralStore example b15 (1997)