WhiteRau Posted May 30, 2011 Share Posted May 30, 2011 i appreciate this a more a mySQL question, but since PHP is how we're interfacing with it... anyone recommend a good engine for frequent read/writes that supports triggers? is FEDERATED the only one? thanks! and apologies if this is out of line. WR! Link to comment https://forums.phpfreaks.com/topic/237855-recommend-a-good-engine/ Share on other sites More sharing options...
mikosiko Posted May 31, 2011 Share Posted May 31, 2011 I will say MyIsam or Innodb (in case you want transactions, referential integrity and row level locking choose Innodb) you can use triggers or stored procedures/functions in both... Federated SE is used to access data (tables) in remote servers.... more information regarding to storage engines and their characteristics here http://dev.mysql.com/doc/refman/5.0/en/storage-engines.html. Link to comment https://forums.phpfreaks.com/topic/237855-recommend-a-good-engine/#findComment-1222688 Share on other sites More sharing options...
fenway Posted June 2, 2011 Share Posted June 2, 2011 They all support triggers. Link to comment https://forums.phpfreaks.com/topic/237855-recommend-a-good-engine/#findComment-1224295 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.