LA.pm: Efficiency
Ask Bjoern Hansen
ask at valueclick.com
Sun Oct 28 18:17:20 CST 2001
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
More information about the Losangeles-pm
mailing list