In such situations like: bulk update in configuration of items or Happening a Huge Event Count on system or Bulk Acknowledge of Triggers ,Update IDS on IDS table may be caused to deadlock on database or may be got a very slow query.
could it use an auto increment number on each table separately as ID to avoid this bottleneck?