LA.pm: Efficiency

[Ask Bjoern Hansen]

On Sat, 27 Oct 2001, Arkadiy Sudarikov wrote:

> Actually... I selected 8 thousand rows from... he he he, Hilton Online
> Reservations History log. I think Hilton Hotel probably is going to have a
> big-ass History log. So, uh, database is huge, and table is huge...

uh, but still: if you are only benchmarking on 8 thousand rows, then
it won't make a difference how you do it. :-)


 - ask

> Unfortunately, I can't tell you right now the COUNT(*) FROM res_history or
> how much space this Sybase instance occupies.
>
> -----Original Message-----
> From: Ask Bjoern Hansen
> To: Arkadiy Sudarikov
> Cc: ''LA.pm' '
> Sent: 10/27/2001 3:29 PM
> Subject: RE: LA.pm: Efficiency
>
> 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