Members   Search   Help    Register    Login   Home

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

Two general MySQL questions.. [message #522] Tue, 02 January 2007 10:17  oordopjes Messages: 15 Registered: January 2007 Junior Member Hi, 1. When using SQL_CALC_FOUND_ROWS combined with a LIMIT and an ORDER BY. Does MySQL stop ordering after the LIMIT is reached? Or are all results ordered by MySQL while getting the SQL_CALC_FOUND_ROWS? If this is the case it probably is faster to do a SELECT COUNT(*) instead..without an ORDER BY. 2. When MySQL (regular INNER??) JOINs two tables.. Does it first do a SELECT on table1 and a SELECT on table2 and then combine the results? Or does it do a SELECT on table1, join it.. and do another select? Thanks! Report message to a moderator

	Two general MySQL questions.. By: oordopjes on Tue, 02 January 2007 10:17
	Re: Two general MySQL questions.. By: Peter on Tue, 02 January 2007 18:51
	Re: Two general MySQL questions.. By: oordopjes on Wed, 03 January 2007 18:23
	Re: Two general MySQL questions.. By: rhuddleston on Tue, 09 January 2007 01:42
	Re: Two general MySQL questions.. By: Peter on Tue, 09 January 2007 05:40

Previous Topic:	InnoDB tablespace inter-version compatibility
Next Topic:	muti-key index order

Goto Forum:

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