Re: Question related to database engine usage in CakePHP
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 Mar 2010, at 23:05, Varga Levente wrote: 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 impact on perfomance (like I said using the features that are present in InnoDB instead of implementing them in PHP). Thanks! On Fri, Mar 12, 2010 at 7:42 PM, Miles J mileswjohn...@gmail.com wrote: 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 -- 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 are subscribed to the Google Groups CakePHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -- 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 are subscribed to the Google Groups CakePHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. You received this message because you are subscribed to the Google Groups CakePHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
Re: Question related to database engine usage in CakePHP
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 impact on perfomance (like I said using the features that are present in InnoDB instead of implementing them in PHP). Thanks! On Fri, Mar 12, 2010 at 7:42 PM, Miles J mileswjohn...@gmail.com wrote: 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 -- 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 are subscribed to the Google Groups CakePHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -- 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 are subscribed to the Google Groups CakePHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
Question related to database engine usage in CakePHP
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 are subscribed to the Google Groups CakePHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
Re: Question related to database engine usage in CakePHP
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 and help others with their CakePHP related questions. You received this message because you are subscribed to the Google Groups CakePHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
Re: Question related to database engine usage in CakePHP
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 -- 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 are subscribed to the Google Groups CakePHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en