LA.pm: Efficiency

[Arkadiy Sudarikov]

I did. About 8 thousand rows. 

-----Original Message-----
From: Ask Bjoern Hansen
To: Arkadiy Sudarikov
Cc: 'LA.pm'
Sent: 10/27/2001 7:35 AM
Subject: Re: LA.pm: Efficiency

On Fri, 26 Oct 2001, Arkadiy Sudarikov wrote:

> I Benchmarked { SELECT COUNT(*) } and { SELECT * and $count++ while
fetch }
> and got same times... Now, what does that mean? Shouldn't one be
"better"
> than the other?

If the database is small the overhead of connecting and all will be
much more than transferring a few rows.

Try with a database with a few hundred thousand large rows.


 - ask

-- 
ask bjoern hansen, http://ask.netcetera.dk/         !try; do();
more than a billion impressions per week, http://valueclick.com