1. Don't use SELECT *. Only grab the cols that you only need. Also
make sure you have an index on min_position and max_position. After
that if your query isn't faster please show us the output of running
EXPLAIN select * from table_name where start_postion between
On Mon, Jul 13, 2009 at 12:03 AM, JingTian<jingtian.seu217@stripped> wrote:
> 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?
A: It reverses the normal flow of conversation.
Q: What's wrong with top-posting?
Q: What's the biggest scourge on plain text email discussions?