· 7 years ago · Sep 15, 2018, 06:54 AM
1How can i speed up query?
2CREATE TABLE IF NOT EXISTS `markersStorage2` (
3 `id` int(11) NOT NULL AUTO_INCREMENT,
4 `name` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
5 `surname` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
6 `id_vk` int(10) NOT NULL,
7 `activity_link` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
8 `message` varchar(256) COLLATE utf8_unicode_ci NOT NULL,
9 `lat` float(10,6) NOT NULL,
10 `lng` float(10,6) NOT NULL,
11 `type` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
12 `id_tile` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
13 PRIMARY KEY (`id`)
14 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
15
16SELECT id, lat,lng FROM markersStorage2 WHERE id_tile LIKE '$tileNumber%'
17
18id_tile = 002013111032032
19
20SELECT id, lat,lng FROM markersStorage2 WHERE id_tile LIKE '002013111032%'
21
22ALTER TABLE `markersstorage2` ADD INDEX `id_tile` (`id_tile`);
23
24ALTER TABLE `markersstorage2` ADD INDEX (`id_tile` ) ;