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
