Re: Simulating sequences

[Peter Brawley]

Quote

This works well until the system is heavily loaded. When heavily loaded, I sometimes get a zero value as the rowsUpdated value. I assume this is because two threads were doing the update at the same time.

last_insert_id() doesn't work with deletion. Any possibility a row was deleted by another process?

No error messages after that execute() call? No errors or warnings in the mysql or php logs?

Did you try putting the code in a standard transaction block with rollback code?



Edited 1 time(s). Last edit at 06/30/2014 04:05PM by Peter Brawley.