Re: Checking for uncommited transactions

Galen Boyer wrote:

> Lets create a table with your scenario:

No, your scenario is different. You just deleted rows, this is not a problem.

> Where is this full table locking?

The table locking occurs only between uncommited inserts.

ID NAME

1      ONE
2      TWO
3      THREE
4      FOUR

USER_SETTINGS: ID USER_ID NAME

1     1         FROM ONE
2     1         FROM ONE
3     2         FROM TWO
4     4         FROM FOUR

Session 1:

Insert a row to user settings (5, 2, 'FROM TWO').

Do not commit.

Session 2:

Try to delete user (3, 'THREE'). This user doesn't have any settings therefore this row should deleted immediately - it doesn't.

Session 2 will wait until session 2 performs a commit/rollback.

-- 
Immo Landwerth - XP Pro - D5 Pro SP1 - XanaNews 1.14.1.1