Hi - I need some help :) I set up a simple mysql table: mysql> describe ip2org; +----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+-------------+------+-----+---------+-------+ | ip_start | bigint(20) | | MUL | 0 | | | ip_end | bigint(20) | | MUL | 0 | | | org | varchar(80) | | | | | +----------+-------------+------+-----+---------+-------+ 3 rows in set (0.00 sec) It's got just over 2 million rows, and is populated with integers.
I do this: SELECT org from ip2org where ip_start<=1094799892 and ip_end>=1094799892; and it take 12 seconds...! all my indexes seem to be there: mysql> explain SELECT org from ip2org where ip_start<=1094799892 and ip_end>=1094799892; | table | type | possible_keys | key | key_len | ref | rows | Extra | ip2org | ALL | ip_start,ip_end | NULL | NULL | NULL | 2943079 |where used | is this normal? the fields are simple numbers, so it should be lightning fast, no? I realize it's a big table, but it's just numbers. this should come back instantly, no? thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
