Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    422
    Provided Answers: 1

    Red face Unanswered: development with transactions.

    Hi,

    I need development a system for a database with transactions, how to do for this development.

    Thank you.

  2. #2
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    I am not sure I get this right.

    If you want to develop your application using transactions, you need a logged database.

    and the following statements:

    BEGIN WORK;
    INSERT....
    UPDATE...
    DELETE...

    ROLLBACK; or COMMIT;
    rws

  3. #3
    Join Date
    Oct 2003
    Posts
    706

    Talking

    Lots of database management systems provide "real transactions." The most obvious and available is probably Microsoft Access. Nearly all SQL-based servers can be expected to provide them.

    The implementation of transactions can vary, however. While the familiar "Microsoft SQL Server" (nee Sybase) uses logfiles and locks, other systems do it differently. Both Postgres and Interbase use "versioning" which actually allows one long query to run, seeing its version of the data consistently, while subsequent updates occur apace, each one creating a "new version" of the data that eventually replaces the old.

    Many people use transactions improperly. In my humble, "a transaction is not meant to exist for a long period of time; only milliseconds." Data in an SQL-based server is really not meant to remain "locked" for a long time. The performance of an SQL-based system can be very, very good if you play into its strengths and very, very bad if you don't.
    ChimneySweep(R): fast, automatic
    table repair at a click of the
    mouse! http://www.sundialservices.com

  4. #4
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    422
    Provided Answers: 1
    Hi,
    But I want to development in informix 4GL.

    Thank you.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •