Hi,
Disable read caching & oplocking first. There will be a performance hit, varies with environment & hardware. I would look at another list method if you are going to have thousands of records in the comboboxes i.e. a grid ?
Disabling oplocking causes the locking to done back at the file on the server, i.e. all users are aware of changes. There are documented bugs that cause loss of data when using transaction tracking.
With regard to the list, I just work down the list until stability is achieved, it varies greatly how far you have to go depending on OS's, Hardware & quality of network cabling.
I would start with disabling autodisconnect, read caching & oplocking, this usually sorts most problems out.
Regards N Mc Donald
>Neil,
>Thanks for the volumes of info.
>In disabling read and write caching, will it severely impact the performance especially when retrieving list of records in comboboxes (that could run into thousands)?
>In disabling opportunistic locking, does it affect VFP form's opportunistic locking mechanism in multiuser environment?
>Thanks
>Yau
Regards N Mc Donald