LA.pm: Efficiency

[Ask Bjoern Hansen]

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