Post reply

Order of transaction process

  • January 27, 2006 at 3:03 pm

    #111460

    Hi to all

    What transactions is process first from SQL.

     

    SQL receives multi transactions at the same time (if this is possible)

    i.e. in this order (insert, read, insert, delete, update, read, read, insert, delete)

     

    What will happen if they come milliseconds apart, what will be the order of process?

    Thanks

    Chaz

    Kindest Regards,

    Chaz

  • January 30, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • January 30, 2006 at 10:42 am

    #617779

    there is no predefined priroty list, in fact the problem is od dml only since they can execute one at a time.

    Moreover the transaction which will take less time is executed first.

  • January 30, 2006 at 11:08 am

    #617783

    Thanks,

    insert into tablename01 select * from tabledump01 (process time 10sec)

    select * from tablename01 (process time 5sec)

    If I insert new records and it takes longer than the select, the select process first?

    I will miss the new records that are inserted.

    is this correct?

    Thanks

    Kindest Regards,

    Chaz

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply