Re: Question related to database engine usage in CakePHP

2010-03-14 Thread Jeremy Burns
Never leave foreign keys, indexes, or anything else that the database should do to PHP. http://www.classoutfit.com/articles/2010/02/cakephp-basic-database-table-tuning-tips/ Jeremy Burns jeremybu...@me.com (Skype) +44 208 123 3822 (jeremy_burns) (m) +44 7973 481949 (h) +44 208 530 7573 On 13

Re: Question related to database engine usage in CakePHP

2010-03-13 Thread Varga Levente
Yeah, but beside that, does CakePHP use some of the features that come with InnoDB (like foreign keys using the database engine instead of implementing it in PHP)? Basically I'm curios is if there is some gain, beside transactions and row locking instead of table locking, that would seriously

Question related to database engine usage in CakePHP

2010-03-12 Thread Varga Levente
Hello! Is something gained if instead of MyISAM engine the InnoDB is used with CakePHP? levi -- Lege, lege, relege, ora, labora et invenies. Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. You received this message because you

Re: Question related to database engine usage in CakePHP

2010-03-12 Thread Dr. Loboto
Transactions, as always. On Mar 12, 6:04 pm, Varga Levente vlzol...@gmail.com wrote: Hello! Is something gained if instead of MyISAM engine the InnoDB is used with CakePHP? levi -- Lege, lege, relege, ora, labora et invenies. Check out the new CakePHP Questions site http://cakeqs.org

Re: Question related to database engine usage in CakePHP

2010-03-12 Thread Miles J
Row locking instead of table locking. On Mar 12, 8:25 am, Dr. Loboto drlob...@gmail.com wrote: Transactions, as always. On Mar 12, 6:04 pm, Varga Levente vlzol...@gmail.com wrote: Hello! Is something gained if instead of MyISAM engine the InnoDB is used with CakePHP? levi --