Re: Need I lock the table?

[Roland Bouman]

If theres no bug or quirk in the code that checks the limit, i guess it's still possible that you're having this problem becaus of concurrency, like:

Time=0: Thread 1 checks the limit, thinks its ok to insert
Time=1: Thread 2 checks the limit, thinks its ok to insert
Time=2: Thread 2 inserts, limit is reached
Time=3: Thread 1 still thinks it's ok to insert, inserts, limit is exceeded

I never tried this, but a quick look in the manual makes me think that you could use locks to prevent this.

By All means, read chapter 13 of the manual. Halfway ,the LOCK TABLES statement is explained.

I hope it helps!