Ensuring your tables are properly indexed and using inner joins where possible would help performance.

I'm pretty sure it's very dependant on the structure of the tables and the format of the query also. Maybe more information would be helpful. Can you post the query?