Members   Search   Help    Register    Login   Home

Show: Today's Messages  :: Show Polls :: Message Navigator

Using SQL_CALC_FOUND_ROWS [message #18] Sat, 12 August 2006 07:25  elektronaut Messages: 9 Registered: August 2006 Location: Switzerland - Zürich - W... Junior Member I found this very nice feature SQL_CALC_FOUND_ROWS to use if you want to get an idea of how many records were found, even though you're using limit. I was delighted to find this. Before I was using a count query which was always very annoying to build and it went against all my instincts;) Is there a catch? Any reason why not to use this feature. It does slow down the query some, but i guess that's to be expected. Thanks for any comments on this. Minds are like parachutes - they work best when open. Report message to a moderator

	Using SQL_CALC_FOUND_ROWS By: elektronaut on Sat, 12 August 2006 07:25
	Re: Using SQL_CALC_FOUND_ROWS By: Peter on Sun, 13 August 2006 09:34
	Re: Using SQL_CALC_FOUND_ROWS By: elektronaut on Sun, 13 August 2006 12:26
	Re: Using SQL_CALC_FOUND_ROWS By: Peter on Sun, 13 August 2006 18:43
	Re: Using SQL_CALC_FOUND_ROWS By: elektronaut on Mon, 14 August 2006 02:46
	Re: Using SQL_CALC_FOUND_ROWS By: Peter on Mon, 14 August 2006 03:38

Previous Topic:	Using Indexes to increase sort performance
Next Topic:	1-n distinct/group by optimization

Goto Forum:

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [ ]