From: JingTian (jingtian.seu217gmail.com)
Date: Sun Jul 12 2009 - 23:03:31 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hi all,

i use "select * from table_name where start_postion between min_postion and
max_postion" to select all the record in the ranges,
when the ranges is very large,such as 8000000(about 1000 record in it), the
query is so slow,

when i use mysql administrator i find that traffic is higher when the query
is begin,

could you please give me some advice on how to optimization the query?

thanks,

--
Tianjing

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]