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ő
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
