MySQL and ORDER BY to speed up query
Posted: Mon Oct 17, 2011 9:27 pm
Hi,
my question is simple, can ORDER BY improve a query speed and performance when we are searching for a number using an indexed field?
Or it doesn't matter for mysql?
i explain better:
So witch one will perform best and faster?
Since ORDER BY put all serverid in order it will be more fast for mysql search and select?
Thanks
my question is simple, can ORDER BY improve a query speed and performance when we are searching for a number using an indexed field?
Or it doesn't matter for mysql?
i explain better:
so looking at this query:My Table wrote:CREATE TABLE `serverplayer` (
`id` int(10) unsigned NOT NULL,
`status` tinyint(3) unsigned NOT NULL DEFAULT '0',
`serverid` int(10) unsigned NOT NULL,
`jointime` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `serverid` (`serverid`),
CONSTRAINT `serverplayer_ibfk_1` FOREIGN KEY (`id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
CONSTRAINT `serverplayer_ibfk_2` FOREIGN KEY (`serverid`) REFERENCES `server` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
Code: Select all
SELECT * FROM serverplayer WHERE serverid = 525 ORDER BY serverid LIMIT 20Code: Select all
SELECT * FROM serverplayer WHERE serverid = 525 LIMIT 20Since ORDER BY put all serverid in order it will be more fast for mysql search and select?
Thanks