Members   Search   Help    Register    Login   Home

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

SELECT * FROM thistable ORDER BY date [message #1729] Mon, 03 September 2007 16:49  sdeluca Messages: 4 Registered: September 2007 Location: France Junior Member Hi there, This is my first post, so let me introduce myself. I develop web sites such as http://mobilezoo.biz and http://boursomac.com and I'm really interested in mysql performances. And I've got a question on a simple situation: I've got a table 'thistable' with an indexed column 'date' which has about 90K lines. date is of DATETIME type, the table is using myIsam and has a primary index in addition to an index on date. When performing EXPLAIN SELECT * FROM thistable ORDER BY date LIMIT 1,100 MySql says it runs through all rows, while still using index 'date'. I certainly missing something here. Why does it need to look at all rows ? Thanks in advance, Sdl Come and enjoy http://mobilezoo.biz and http://boursomac.com Report message to a moderator

	SELECT * FROM thistable ORDER BY date By: sdeluca on Mon, 03 September 2007 16:49
	Re: SELECT * FROM thistable ORDER BY date By: Peter on Tue, 04 September 2007 07:25
	Re: SELECT * FROM thistable ORDER BY date By: sdeluca on Tue, 04 September 2007 08:16
	Re: SELECT * FROM thistable ORDER BY date By: Peter on Wed, 05 September 2007 10:26
	Re: SELECT * FROM thistable ORDER BY date By: Peter on Wed, 05 September 2007 10:27

Previous Topic:	Tables get locked and won't unlock
Next Topic:	dinamyc images

Goto Forum:

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