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



hancocj
Novice

Nov 7, 2002, 12:28 PM


Views: 6050
Estimating Query results...

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. Google.com's search results page is a good example of what I am talking about.

Any ideas?


Paul
Enthusiast

Nov 8, 2002, 4:10 AM


Views: 6047
Re: [hancocj] Estimating Query results...

$sth->rows