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.
I realize that this statement is probably an antiquated guideline.....and
I'd like to know if its still true (or if in fact it was ever true!)
Regards,
Gary "SuperID" Huntress
=======================================================
FreeSQL.org offering free database hosting to developers
Visit http://www.freesql.org
----- Original Message -----
From: "Chris 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 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 is
> updated when a row is inserted, so the query doesn't actually count all
the
> rows).
>
> > 3. select field1,field2,field3 from tbl
>
> This will be faster than select * since it doesn't have to fetch as much
> data.
>
> See http://www.mysql.com/doc/Q/u/Query_Speed.html for more information.
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
