Network delay

[KoMiKo]

I am working on network application for specific competitions. There are two or more PCs connected in the same LAN, database is splitted.
My idea is folowing: On one computer user will start competition (write to table "StartTime" and CompetitionON As Boolean = True ). Another one or more computers in the same LAN are reading "CompetitionON" value in loop and when there is True, it will read "StartTime" and fire stopwatch ( Now() - StartTime, finest resolution seconds is enough). Computers have synchronized Windows times to show the same time.



Using DAO.Recordsets

Everything is working, my only problem is delay about 2 to 4 seconds between write and start the stopwatch.

Do you have any idea how to speed up this "reaction time"? Below one second it would be OK.

[CJ_London]

just a one off suggestion - reduce the time for your loop

[KoMiKo]

just a one off suggestion - reduce the time for your loop

This is not problem. I have simple test app to meassure delay with two forms (frmWrite, frmRead), where frmRead Me.TimerInterval = 100 (ms).