>We were sending to each other at the same time on this issue.
>
>Just yesterday I added the FLUSH command after incrementing the ID, and as of now, there doesn't seem to be any conflicts. Will be watching it and let you know.
I put in the FLUSH command, but it seems to slow things down. I was previously closing the table after incrementing the ID. Shouldn't that have the same effect? Someone told me that FLUSH only works on local drives, not on a network. Is this true?
Elyse Pomerantz