Hi mk,

I suspect this is because of exclusive or opportunistic locking.
This means that when only one computer is using the application, the tables are exclusively openened on the server for that computer. It enables write and read chaching in that computer.

This is an optimizing mechanism of windows networks.

When a second computer logs in, it will force the other computer to flush its writebuffers and purge its read buffers (as soon as the other computer is writing something to the table). This of course is less optimal and is far slower. Search the MS kb for more info on this topic.

This behaviour is by design and it the most optimal setting performance wise.

Now your problem probably is caused by suboptimal table handling and index usage.
You'll have to try to find out how you could prevent unneccesary data to be transferred from the server to the computer.

So in your design, you'll have to make sure that you only access and process the data you need.
Further try to optimize queries by making sure the least amount of records are downloaded from the network. You can use filemon (free utility available from www.sysinternals.com) to determine what goes accross the network.








>i got the hint when this software working slow.
>but i do not know the solution.
>
>i have 3 computer.all with windows XP.
>
>computer 1 Main Computer, data files in this computer, this user also entring the data.
>
>Computer 2 User1
>Computer 3 User2
>
>when i am using software on computer 2
>and not on computer 3, it work with greate speed.
>
>when i am using software on computer 3 and not on computer 2, it work with greate speed.
>
>but when computer 2 and computer 3 both entering
>sales and saving a record, this time it is very slow.
>
>what i should check out for this.
>
>warm regards,
>mk.