Sergio Salvi wrote:
Hi!
Can you send the output of the following command?
show index from ip2org;
It seems you don't have an index on both fields (even though it says you have multi-field index)...
MUL doesn't mean part of a multi-field index. From the manual <http://dev.mysql.com/doc/mysql/en/DESCRIBE.html>: "The MUL value indicates that multiple occurences of a given value allowed within the field."
[]s, Sergio Salvi.
On Thu, 24 Jun 2004, MerchantSense wrote:
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]
