Improving my database

[scialom]

Hi,

I develop an application that requires a lot of queries from the db.
Basically I have first query that take the projects name from one table, and then I have for each project another query that take from a different tables the relevant data for the specific project. Now it works fine, but lately it become very slowly, because we have a lot of records.

My question is if there is anyway to improve the speed?

Thanks,
Assaf

[bastien]

Can you post your table structure?
Are you using indeces?

What is your code like?

[Sxooter]

See if you can use joins to drop the count of the queries down to one or two, and reduce the amount of lookups you have to do in php. Something like:

select * from projects p left join details d on (p.id=d.pid) where...