> 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
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
2 select count(*) from tbl
3. select field1,field2,field3 from tbl
TIA
Chris Penning
CSM Systems Inc.
Edmonton, AB
T5J 3S9, Canada
