Re: [PHP-DB] Optimal mySQL query for next prev page system

2003-11-19 Thread Kim Steinhaug
Thanks for the replies. Its time for me to start do some patching for my SQL statement, :) -- Kim Steinhaug --- There are 10 types of people when it comes to binary numbers: those who understand them, and those who don't.

[PHP-DB] Optimal mySQL query for next prev page system

2003-11-18 Thread Kim Steinhaug
Ive been using the same way of creating queries for the mySQL database the last years now, but as my databases keep growing Its time to start thinking of performance. My question however, is more if the way im doing this is the best way, or if I should reprogram all my queries in a more optimal

Re: [PHP-DB] Optimal mySQL query for next prev page system

2003-11-18 Thread Adam i Agnieszka Gasiorowski FNORD
Kim Steinhaug wrote: Then I query the mySQL database again to get the final result set, which I return together with the buildt prev/next htmlkode Instead of querying twice, use the SQL_CALC_FOUND_ROWS parameter of SELECT statement and then do a quick SELECT HIGH_PRIORITY

Re: [PHP-DB] Optimal mySQL query for next prev page system

2003-11-18 Thread John W. Holmes
Adam i Agnieszka Gasiorowski FNORD wrote: Kim Steinhaug wrote: Then I query the mySQL database again to get the final result set, which I return together with the buildt prev/next htmlkode Instead of querying twice, use the SQL_CALC_FOUND_ROWS parameter of SELECT statement and then do