>I have more than one table to insert incremental fields.
>Do you think is better to create only a NewKey table with several
>fields, or is it better to create a NewKey_x table to each table ?
Create NewKey table with TWO fields:
TableName
Key
And then instead of using FLOCK() use RLOCK() to lock only record for that table you need.
:-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.