>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!

10000 records is not yet huge data compare to more than 500000 thousand close to 1M of ours. We are using VFP database. Anyway what is your back-end database? Are you using C/S technology?