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

2008-06-17 Thread landavia
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 so

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

2008-05-09 Thread Gergely Hodicska
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