Table contains 10000 records. right now around 60 user connected and
accessing the appplication. we are creating a new records which depend on
table's primary key. by the front hand Query with where clause fetch all the
records and get a maximam serial number of records . during this query it's
giving timeout expired.

the table doesn't have lock. server is restarted.

do we need to change any hardware configuration or there is any software
solution.