>>UPDATE or INSERT into these two tables happening in exactly the same time as you do SELECT-SQL.
>
>Well, the member table is updated several times per second. So, does this mean I could detect that in my data provider and simply issue a retry if I catch this error?
Why no try dirty reads for the SQL instead?
If it's not broken, fix it until it is.
My Blog