When Database is large,even single record queries are slow

divya3007 · **Joined:** Tue Mar 25, 2008 12:25 am **Posts:** 3

When I am using large database, even a single record query takes a long time to be retrieved from the database. Can anyone help me on this issue?

Manju,
mnair_77@yahoo.com

divya3007 · **Joined:** Tue Mar 25, 2008 12:25 am **Posts:** 3

[quote="divya3007"]When I am using large database, even a single record query takes a long time to be retrieved from the database.
Example: "Select * from table where user_id=30" also takes a long time to retrieve data.

Have anyone faced similar problem? Can anyone help me on this issue?

schauder · **Joined:** Thu Jul 05, 2007 9:38 am **Posts:** 287

What do your selects look like?

How do your indexes look like?

Is your db actually using the db

divya3007 · **Joined:** Tue Mar 25, 2008 12:25 am **Posts:** 3

schauder wrote:

What do your selects look like?
Select u from user where id=10 . Here id is a primary key

How do your indexes look like?
I have done indexing based on the queries I need, even these queries are getting slow as the size of the db and table grows.

Is your db actually using the db

I didn't follow this question

schauder · **Joined:** Thu Jul 05, 2007 9:38 am **Posts:** 287

schauder wrote:

Is your db actually using the db

divya3007 wrote:

I didn't follow this question

Well I can relate to that. I meant to ask.

Is your db actually using the indexes?

The questions aim at the sql/db being the cause of the problem.

Another possible cause would be a bloated session. How many objects do you have in the session?

Jens