3000 rows are no big deal. 7 to 8 seconds seems long. Most likely,
there is either something wrong with your query, or you are missing a
needed index.
We can't tell you how to improve your query, however, without seeing
the query. We can't tell you if the table structure is the problem
with
hi All,
I am trying to fech some data from some interrelated tables. I am using
inner joins to relate tables. but mysql takes 7-8 sec to execute the query.
What could be the reason of such delays ? I would like to specify that one of
the interrelated table contains around 3000 rows.