explain select blockid from ipblock where 32222222 < ip_int_start; +----+-------------+---------+------+----------------+------+---------+------+---------+-------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +----+-------------+---------+------+----------------+------+---------+------+---------+-------------+ | 1 | SIMPLE | ipblock | ALL | ip_info_active | NULL | NULL | NULL | 1732405 | Using where | +----+-------------+---------+------+----------------+------+---------+------+---------+-------------+
On Mon, Mar 29, 2010 at 4:20 PM, Joseph Scott <[email protected]> wrote: > On Mon, Mar 29, 2010 at 4:13 PM, Eric Goebel <[email protected]> wrote: >> I've found that the between operation doesn't use the index very well. >> Is there another type of index I could use or a better way to optimize >> this data for a faster lookup? > > > Sounds like you've run EXPLAIN on this query then. What does the > EXPLAIN output look like? > > > -- > Joseph Scott > [email protected] > http://josephscott.org/ > _______________________________________________ UPHPU mailing list [email protected] http://uphpu.org/mailman/listinfo/uphpu IRC: #uphpu on irc.freenode.net
