nextId() and ON DUPLICATE KEY UPDATE

[soladon13]

Hello,

I am using ON DUPLICATE KEY UPDATE to insert/update rows in a large table. The problem is most times it is the UPDATE part that is executed, meaning that the nextId() that was called earlier incremented the sequence for no reason.

The thing is that updates happen often and the id of the sequence would get huge(!) in little time compared to the actual number of entries of the table.

Any ideas please?

Thank you,