Performance - Newbie

[Deepak Goel]

Hello

I have a fairly simple database (10 tables) and there are simple queries being fired at it (read and insert).

A few days back we started with a few thousand records. The query times were in msec.

Today, due to load there were about 200,000 records in the database. The query time have shot up to about 10 seconds.

I am expecting the number of records to go to a few million in the next couple of days. The query times would also shoot up (and probably go upto 50 secs and more)

There is plenty of hardware available. So how do I go about performance-tuning this setup (and the query response time stays in msec even if the database record size goes up to 25 million)

Any pointers.

Thanks!