Banking transaction is critical because it's more on client related thing, while querying reports and backups are for internal. go for INNODB. ________________________________ From: Amit Kumar Dube <chicku_dube@xxxxxxxxx> To: php-objects@xxxxxxxxxxxxxxx Sent: Wed, March 3, 2010 5:31:36 PM Subject: Re: Hi can any body help me in this decision! In MYSQL INNODB engine is use for transaction application. I think you are using right engine Amit Kumar Dube --- On Wed, 3/3/10, zubair nawaz awan <zubairnawazawan@ yahoo.com> wrote: From: zubair nawaz awan <zubairnawazawan@ yahoo.com> Subject: Hi can any body help me in this decision! To: php-objects@ yahoogroups. com Date: Wednesday, March 3, 2010, 1:13 AM Hi all, My team is going to build a web application for a banking system in PHP/MYSql where there is a transaction based entries...mean (partial executed statement) that force me to choose INNODB engine for MYSql....and on the other way there will be reporting where select queries will decrease the speed and also backups issues.....that force me to use MYISAM... I have done much of the search on google for both but currently very confused...so need some guide line from ur side. Plz give me ur suggesstions. .....what should i use. i will be thank full to u. thanx Regards Zubair Nawaz Awan [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]