LA.pm: Efficiency

[Ask Bjoern Hansen]

On Sat, 27 Oct 2001, Arkadiy Sudarikov wrote:

> I did. About 8 thousand rows.

Uh, that's a really really small database (unless you store many
megabytes in each row).

How big is the table (in megabytes)?


 - ask

> -----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