The data of my system is located at the network.
When the numbers of record increase to about 10000, the speed of the system become very slow. It require about 1 or 2 min. to save a record. Is all of your system face the same problem?
The approach that i used in the system is :
Users input the data at the grid
When Saving, the grid's data is replaced to the server's table

i have set all the required index in the tables.

So, Pls help me and suggest any other ways to improve the performance in the system

Thanks!