Subject Re: [firebird-support] Performance - Querying newly inserted records for processing - which better?
Author Martijn Tonies
Hi Kenneth,

> Which is faster to query for newly inserted records for some task
> METHOD 1 - Use a composite key with a field denoting 'N' for newly
inserted rows, 'P' for processed rows. Once processed, update this indexed
field from 'N' to 'P'.
> METHOD 2 - Use another table to keep the IDs of newly inserted rows

I would go the Method 2.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Upscene Productions