Hi Kenneth,

> Which is faster to query for newly inserted records for some task

processing?

>
> 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
Server.
Upscene Productions
http://www.upscene.com