>Dear All,
>My network uses peer to peer and the switch hub is used for the network. The forms opening with many Sql squeries by one station is very fast and the data display will complete less than 1 second but two stations or more stations opening same form is very slow and each station takes several seconds to complete the data display in a form.
>
>I also put the same program and data in other similar network enviroment and it comes out the same problem.
>
>Form opening for one station is fast but slow down signicantly for two or more stations for same form.
>
>Can anyone encounter such problem? Please advise any solution to solve the problem.

First user get's oplock level 1. Second user causes level 1 oplock to be broken and changed to level 2.

http://msdn.microsoft.com/en-us/library/cc308442.aspx

Disable write caching and oplocks. Install the application on each workstation with an application launcher/loader.