K
kamflam
We have an NT wkstn which writes to a table on an mdb on our Win2000 server
It writes to this table about twice per second ..for hours on end
We've noticed that periodically (sometimes every 36 writes for example), but sometimes not periodically (it may go several hundred writes before this event occurs), the standard write time of 10 milliseconds or 20 milliseconds changes to 252ms or occasionally even 500 ms
This 250 and 500 are interesting in that they are equal to the default RETRY INTERVAL of 250ms and its RETRY ATTEMPTS of 2. The pc which is making these writes is running a RUNTIME version of Access97
The records are quite small..and the number of records in the interval x #of bytes does not come close to the 2k page lock
But still there appears to be some sort of LOCKING ISSUE here ... which occurs often with exact frequency (ie.. of 35 writes), and then other times that frequency may be 85 writes ...and then sometimes there is no identifiable frequency at all
Can anyone shed some light on this anomoly
thx
It writes to this table about twice per second ..for hours on end
We've noticed that periodically (sometimes every 36 writes for example), but sometimes not periodically (it may go several hundred writes before this event occurs), the standard write time of 10 milliseconds or 20 milliseconds changes to 252ms or occasionally even 500 ms
This 250 and 500 are interesting in that they are equal to the default RETRY INTERVAL of 250ms and its RETRY ATTEMPTS of 2. The pc which is making these writes is running a RUNTIME version of Access97
The records are quite small..and the number of records in the interval x #of bytes does not come close to the 2k page lock
But still there appears to be some sort of LOCKING ISSUE here ... which occurs often with exact frequency (ie.. of 35 writes), and then other times that frequency may be 85 writes ...and then sometimes there is no identifiable frequency at all
Can anyone shed some light on this anomoly
thx