Go4Expert

Go4Expert (http://www.go4expert.com/)
-   MySQL (http://www.go4expert.com/forums/mysql-forum/)
-   -   Transactions in Databases (http://www.go4expert.com/forums/transactions-in-databases-t15883/)

Salil 20Jan2009 21:29

Transactions in Databases
 
Hello Friends,
I am currently working on a Mysql database and our architects are dead against using transactions in our queries. In order to solve transaction problems we are forced to use temp tables and flags which itself doesn't solve the transactional integrity problem by a lot but just minimizes it. Also our tables have no referential integrity built in. I was wondering if it is possible for any real world applications to function without using transactions and referential integrity.

shabbir 20Jan2009 21:53

Re: Transactions in Databases
 
Yes very much but not on a very large scale where you need the ACID functionality to be critical in performance.

What you would ultimately use may be of more overhead actually and try to convince the situation to the Architects

BTW Who made them the architects.

Salil 20Jan2009 22:24

Re: Transactions in Databases
 
Quote:

Originally Posted by shabbir (Post 41754)
Yes very much but not on a very large scale where you need the ACID functionality to be critical in performance.

What you would ultimately use may be of more overhead actually and try to convince the situation to the Architects

BTW Who made them the architects.

I am sorry, but I couldn't understand what your reply meant? Are you saying there are real world apps out there that work without using transactions and use flags and temp tables. I come from a EJB background and I haven't seen a lot of apps like that.


All times are GMT +5.5. The time now is 16:13.