View Single Post
Old 12-03-2007, 07:26 PM   #5 (permalink)
Erutan409
The Visitor
 
Erutan409's Avatar
 
Join Date: Sep 2007
Posts: 4
Thanks: 4
Erutan409 is on a distinguished road
Default

Quote:
Originally Posted by bluesaga View Post
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?
Erutan409 is offline  
Reply With Quote