Re: Embedded SQL - performance question

On 5/27/2011 2:47 PM, Bryce Martin wrote:

essentially... the record would need to be added within the amount of time
that it takes to do an "if %found" check...

It's not just the time taken to do the "if %found"; its the time between when database determined there was no record to the time that your WRITE request reaches database.

Say some other job was starting a WRITE at around the same time as your CHAIN, but when when database does the check for the record for your CHAIN, the WRITE operation in the other job hasn't reached database yet. When your job finds that the record is not there, it will start its own WRITE operation, but that other job had a head start, and would have got the record in first.