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! Quote 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. Quote 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. Quote Link to comment https://forums.phpfreaks.com/topic/237855-recommend-a-good-engine/#findComment-1224295 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.