Re: [PHP-DB] Re: [PHP] Best practices for using MySQL index

i agree. But InnoDB not fast like other, but this using for transaction. 
u should try to examine, if you choose performance.. chose other. If u 
use transaction, INNODB perhaps u can use?
*sry my bad LANG

Gergely Hodicska wrote:
> Hi!
>
>
>> While this is not a MySQL mailing list, I try to give you some hints 
>> and keep it short.
> There is maybe one important thing which should considered: clustered 
> index. If use InnoDB you can think about to not using a surrogate key 
> but a natural one which best support the query which you will use in 
> most cases.
>
> An InnoDB table's primary key is a clustered index and querying 
> against it is very fast.
>
>
> Best Regards,
> Felhő
>