Re: Slow Code, how to speed up

This WebDNA talk-list message is from

2002

It keeps the original formatting. numero = 41120
interpreted = N
texte = Just a quick thought,Try this. Pulled count search out of the append. Also, since you don'treally need any of the data returned, there is no reason to sort it oranything which will add time to your query. I think this will be faster.[!] Search Temp Database [/!][search db=referer.txt&neREFERRERdatarq=findall&REFERRERsumm=t][founditems][!] Append to Temp 2 Database [/!][math]myCounter=0[/math][search db=referer.txt&eqREFERRERdatarq=[url][REFERRER][/url][math]myCounter=[numfound][/math][/search][append db=templog2.db]referrer=[referrer]&count=[myCounter][/append][/founditems][/search]On 7/1/02 9:02 PM, Jeff Logan wrote:> 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 Management> > Toll 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/-------------------------------------------------Charles Kline email: ckline@rightcode.netPresident phone: 856.608.7908RightCode, Inc.900 Briggs Road, Suite 303Mt. Laurel, NJ 08054http://www.rightcode.net -= fuel for websites =--------------------------------------------------------------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:

Re: Slow Code, how to speed up (Charles Kline 2002)
Re: Slow Code, how to speed up (Jesse Williams-Proudman 2002)
Re: Slow Code, how to speed up (Grant Hulbert 2002)
Re: Slow Code, how to speed up (Charles Kline 2002)
Re: Slow Code, how to speed up (Charles Kline 2002)
Re: Slow Code, how to speed up (Grant Hulbert 2002)
Slow Code, how to speed up (Jeff Logan 2002)

Just a quick thought,Try this. Pulled count search out of the append. Also, since you don'treally need any of the data returned, there is no reason to sort it oranything which will add time to your query. I think this will be faster.[!] Search Temp Database [/!][search db=referer.txt&neREFERRERdatarq=findall&REFERRERsumm=t][founditems][!] Append to Temp 2 Database [/!][math]myCounter=0[/math][search db=referer.txt&eqREFERRERdatarq=[url][referrer][/url][math]myCounter=[numfound][/math][/search][append db=templog2.db]referrer=[referrer]&count=[myCounter][/append][/founditems][/search]On 7/1/02 9:02 PM, Jeff Logan wrote:> 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 Management> > Toll 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/-------------------------------------------------Charles Kline email: ckline@rightcode.netPresident phone: 856.608.7908RightCode, Inc.900 Briggs Road, Suite 303Mt. Laurel, NJ 08054http://www.rightcode.net -= fuel for websites =--------------------------------------------------------------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/ Charles Kline

DOWNLOAD WEBDNA NOW!

Re: Slow Code, how to speed up

2002

Top Articles:

Related Readings: