MySQL Query In Theory

dbchip2000

Hi,
I am wondering if it is better (for speed) to:
- create one advanced query without a LIMIT and ORDER BY to determine the number of records total and then another query with LIMIT and ORDER BY to process for display
- or create one advanced query with only LIMIT and then seek to the appropriate records for display

 I am hoping someone has more experience in this area and can provide some insight.  Thanks!
 -Danny

redlorry919

Hello,

The second option would obviously be slightly faster as it's running 1 query instead of 2. However, I think you'd need to run the first option anyway so you can display page numbers/next/previous links otherwise there's no telling how much data to return.

Generally, I think with the speed of mysql, there'll be no noticable difference in the speed of your site if you run the first option.

Regards,
Adam.

mrhappiness

one query with COUNT and no LIMIT or ORDER BY (you get one single entry inly so there's no need to order anything)

one query with LIMIT and ORDER BY for retrieving only the desired entries