Transactions in Databases

Discussion in 'MySQL' started by Salil, Jan 20, 2009.

  1. Salil

    Salil New Member

    Joined:
    Mar 23, 2007
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    0
    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.
     
  2. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,375
    Likes Received:
    388
    Trophy Points:
    83
    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.
     
  3. Salil

    Salil New Member

    Joined:
    Mar 23, 2007
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    0
    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.
     

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice