MySQL queries
MySQL queries
Out of context: Reply #1
- Started
- Last post
- 2 Responses
- enobrev0
it all depends on how much each query is taking and how unrelated they are. The 'right' way has less to do with how many queries and more to do with how quick all the queries can be iplemented.
Sometimes 6 joins will be quicker than 3 queries, and other times it's far slower.
The best thing to do is time your queries. Maybe even build a query profiler into your database functions and watch them over time. something that lists the page called form, the query time and the total script time.