Geneos - Why are there duplicated items with the same time stamp for the same data item in Database Logging?

By default, the database schema shipped with the gateway prevents (on Oracle and Sybase at least) duplicates because the time stamp is part of the primary key, however as a DBA you can override this in the database schema directly by changing the primary key. If you do then some situations can result in duplicate time stamps for the same data item in the database:

1) You are using a sampler where the update rate is not restricted, most common among these is the API sampler.

2) The time stamps are being generated by the gateway, and as such it is possible because of delays in processing netprobe updates that two updates get written to the database in the same second.