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 min_postion and max_postion" .
On Mon, Jul 13, 2009 at 12:03 AM, JingTian<jingtian.seu...@gmail.com> 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? > > thanks, > > -- > Tianjing > -- A: It reverses the normal flow of conversation. Q: What's wrong with top-posting? A: Top-posting. Q: What's the biggest scourge on plain text email discussions? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
