When to use MyISAM or InnoDB
View Single Post
12-03-2007, 07:26 PM
Join Date: Sep 2007
Originally Posted by
I think the key thing should be noted is that large website with a ton of writes, will need an INNODB table for writing, no doubt in that. However, a website that has 100% reads, but writing done in the background, it is best to have an INNODB table for the backend (writing) that is copied to the front end which is a MYISAM table.
Copying to the front end can be done like:
INSERT INTO table SELECT * FROM write_table
When should the written data be moved into the active reading table? Should written data be removed from the write table after a certain period of time?
View Public Profile
Send a private message to Erutan409
Visit Erutan409's homepage!
Find More Posts by Erutan409