> I've used a rule of thumb that I was told ages ago when working on other
> databases that inserting records into a non-indexed table is faster
> generally than inserting records into an identical but indexed table.
Makes sense to me, since it has to update the indexes in the latter case.
Howeve
s Bolt" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, June 08, 2001 7:26 PM
Subject: RE: Speed of query
> > Hello all,
> >
> > does anyone have any feedback whether there is any difference in the
> > efficiency of the following query on a fair
> Hello all,
>
> does anyone have any feedback whether there is any difference in the
> efficiency of the following query on a fairly large dataset
>
> 1. select * from tbl
This will be the slowest.
> 2 select count(*) from tbl
This will be very fast since MySQL is optimized for it (the number
