Re[4]: duplicate record Id's in multi user environment

Hello Richard,

Sunday, October 15, 2000, 1:48:23 PM, you wrote:

> My concern is not that two people can read the data area at the same time.
> My concern is that writing the data area requires a synchronous disk write.
> If a physical IO is required, I think that my timings are correct - less
> than 1 millisecond for a read or write, between 3 and 4.5 milliseconds for
> average latency depending on rotation speed.

Ok Richard, I thought you were telling everyone that there was a
possibility for the data area to become corrupt (in the logical
sense). I agree that it does require a sync write, but in the case
that the gentleman asked about (up to 10 users at the same time... ie.
low transaction volume) it should present no problem, even if he
increased it to 100 hits per second it should be fine.

What would you suggest? A user space? Or user index? If I am thinking
correctly you would have to use a mutex for those approaches and that
might require a sync write too. Just curious... I am always interested
in learning better ways of doing things.

BTW if I remember correctly the trigger test I did was incrementing a
data area.


+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---