> I am using a VB6 application on two workstations to concurrently access a
> data file on a server. The exact steps that are happening are in the
> following msdn article:
> http://msdn.microsoft.com/en-us/library/aa365436(VS.85).aspx in the first
> section, which is titled "Level 1 Opportunistic Lock". My problem is that at
> Event 10 (in the example) the Write operation is transferring an enormous
> amount of data. All my program does is opens the data file for random access
> (read and write) and writes a 100 byte structure to record 2 150,000 times
> (it's a benchmark program to figure out what is causing the slowdown). At
> Event 3, the write takes 2-3 seconds and transfers no data (since, as the
> only opened handle, the file is cached onto the workstation). At Event 10,
> the same write takes about 60 seconds and transfers through the network
> roughly 540 megabytes over the 60 seconds! The only requirement for the
> solution is that closing the file before the second workstation opens the
> file to write is NOT an option. Both programs need to keep the file open
> indefinitely.
>
> Things I have tried:
> Changing the access parameters on the open statement.
> Writing with a smaller record structure.
> Writing a file of different file sizes.
>
> Results were all the same: massive slowdown.
>
> Please help!