CGI/Perl Guide | Learning Center | Forums | Advertise | Login
Site Search: in

  Main Index MAIN
Search Posts SEARCH
Who's Online WHO'S
Log in LOG

Home: Perl Programming Help: DBI:
Estimating Query results...



Nov 7, 2002, 12:28 PM

Post #1 of 2 (7093 views)
Estimating Query results... Can't Post

Hi all:

I've noticed in some of my larger mysql databases that the numrows function adds 1-3 seconds to the duration of a query. I really want to display the qeury results in a speedy fashion, as you would. So I was wondering if there is a calculation to estimate the number of results as apposed to actually counting each one. Thus making the query run faster.'s search results page is a good example of what I am talking about.

Any ideas?


Nov 8, 2002, 4:10 AM

Post #2 of 2 (7090 views)
Re: [hancocj] Estimating Query results... [In reply to] Can't Post



Search for (options) Powered by Gossamer Forum v.1.2.0

Web Applications & Managed Hosting Powered by Gossamer Threads
Visit our Mailing List Archives