[EMAIL PROTECTED] (hezjing) writes:
When and why we create tables in different storage engines within a same
database?
Take for example a normal inventory application that provides CRUD operation
to
- USER table (e.g. create new user)
- STOCK table (e.g. when there is new stock arrives)
Hi
When and why we create tables in different storage engines within a same
database?
Take for example a normal inventory application that provides CRUD operation
to
- USER table (e.g. create new user)
- STOCK table (e.g. when there is new stock arrives)
- CUSTOMER table (e.g. create new
How about ...
Use InnoDB for all the transaction important data. Maybe you want to
create a powerful search for your stock table, though and maybe that
table contains millions of records.
You can't use full-text search with InnoDB but you can with MyISAM. You
could put some of the