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@xxxxxxxxx> wrote: From: zubair nawaz awan <zubairnawazawan@xxxxxxxxx> Subject: Hi can any body help me in this decision! To: php-objects@xxxxxxxxxxxxxxx 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]