Did you look at the execution plan on the query to see if there are any bottlenecks or possible improvements?

Do you have proper indexes on the tables based on your querying needs?

Also, it would help if you posted the table structure, sample data and the query.

Mark