Re: How can I optimize this query?

[Martin Schiff]

Rick,

Thanks for your quick reply. Sorry I took so long to get back, but we had some family issues this weekend.

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	<derived2>	ALL	NULL	NULL	NULL	NULL	151	Using temporary; Using filesort
1	PRIMARY	cb	ALL	PRIMARY,startIpNum,endIpNum	NULL	NULL	NULL	3786204	Range checked for each record (index map: 0xD)
1	PRIMARY	cl	eq_ref	PRIMARY	PRIMARY	33	geoipdb.cb.locId	1	 
2	DERIVED	stats	range	longip	longip	38	NULL	6	Using where; Using index for group-by

CREATE TABLE `cityblocks` (\n  `startIpNum` bigint(10) NOT NULL,\n  `endIpNum` bigint(10) NOT NULL,\n  `locId` mediumint(9) NOT NULL,\n  
PRIMARY KEY  (`startIpNum`,`endIpNum`),\n  KEY `locId` (`locId`),\n  KEY `startIpNum` (`startIpNum`),\n  KEY `endIpNum` (`endIpNum`)\n) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci

geoipdb.cityblocks	check	status	OK