Slow Code, how to speed up
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 41116
interpreted = N
texte = Here's code that takes 1600 ticks to process on my server. How can I speed it up? It is opening a 700k file and then processing it, and the file is getting larger at all times, since it is a list of referrering web sites.[!] Search Temp Database [/!] [search db=referer.txt&neREFERRERdatarq=findall&REFERRERsumm=t][founditems][!] Append to Temp 2 Database [/!] [append db=templog2.db]referrer=[referrer]&count=[search db=referer.txt&eqREFERRERdatarq=[url][REFERRER][/url]&deDTsort=1&DTtype=date &max=1][numfound]&dt=[founditems][dt][/founditems][/search][/append] [/founditems][/search] Thanks, Jeff Logan InsideOut Marketing and Web Solutions - 229 South Sequim Ave, Sequim, WA 98382 Web Design and Hosting, Business Marketing, Print Design and ManagementToll Free: 1-800-500-8401 Phone: 360.683.5774 Fax: 360.683.5857 Email: mailto:jeff@insideout.com Web: http://www.insideout.com----------------------------------------------------------------- Learn about our company at http://www.savvyinnkeeper.com Demo our B&B hosting features at http://www.sampleinn.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 Web Archive of this list is at: http://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Here's code that takes 1600 ticks to process on my server. How can I speed it up? It is opening a 700k file and then processing it, and the file is getting larger at all times, since it is a list of referrering web sites.[!] Search Temp Database [/!] [search db=referer.txt&neREFERRERdatarq=findall&REFERRERsumm=t][founditems][!] Append to Temp 2 Database [/!] [append db=templog2.db]referrer=[referrer]&count=[search db=referer.txt&eqREFERRERdatarq=[url][referrer][/url]&deDTsort=1&DTtype=date &max=1][numfound]&dt=[founditems][dt][/founditems][/search][/append] [/founditems][/search] Thanks, Jeff Logan InsideOut Marketing and Web Solutions - 229 South Sequim Ave, Sequim, WA 98382 Web Design and Hosting, Business Marketing, Print Design and ManagementToll Free: 1-800-500-8401 Phone: 360.683.5774 Fax: 360.683.5857 Email: mailto:jeff@insideout.com Web: http://www.insideout.com----------------------------------------------------------------- Learn about our company at http://www.savvyinnkeeper.com Demo our B&B hosting features at http://www.sampleinn.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 Web Archive of this list is at: http://search.smithmicro.com/
Jeff Logan
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:
WebDNA tags in WebMerchant email templates ... (1997)
WebCatalog stalls (1998)
[WebDNA] ENCRYPTION problems (2012)
Re:Searching for ALL / empty form field (1997)
nested context (1998)
[date format] w/in sendmail (1997)
why won't this work, please tell me??? (2001)
POSTing to a secure server ... (2000)
in conversions.db crashes unix webcat (1999)
Great product and great job ! (1997)
2.0Beta Command Ref (can't find this instruction) (1997)
triggers have stopped once again (2002)
WebCat for Site Search? (1997)
I'm having trouble using [url][interpret][math] together in lookup (1997)
[WebDNA] Webdna and CMS (2012)
Fwd: Problems with Webcatalog Plug-in (1997)
WebCatalog NT beta 18 problem (1997)
Database Updates (1997)
Questions To Answer (1997)
WebCatalog Review (2001)