Hi all,

I have a table with about 5,000,000 records and it's growing.

I run slq statement like this :

Select * from table where field_value = 1.

Table already indexed on field_value (int type).

On local hardisk, where there is only 1 user and no update/edit/insert operation, it took about 1-2 seconds to get the result, but on Local Area Network, where there about 20 users attached to that database, lots of update/edit/insert operation on this table,it took almost 20 seconds.

Is there any tips / methods to improve performance?

Thanks and regards,
Anto.