TalkPHP - View Single Post

bluesaga · 11-15-2007, 04:35 PM

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

11-15-2007, 04:35 PM	#3 (permalink)
bluesaga Super Moderator Join Date: Sep 2007 Posts: 165 Thanks: 0	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 __________________ Halo 3 Cheats