List:General Discussion« Previous MessageNext Message »
From:JingTian Date:July 13 2009 4:03am
Subject:mysql select query
View as plain text  
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

Thread
mysql select queryJingTian13 Jul
  • Re: mysql select queryDarryle Steplight13 Jul
    • Re: mysql select queryTianJing13 Jul
      • Re: mysql select queryDarryle Steplight13 Jul
        • Re: mysql select queryTianJing13 Jul
          • Re: mysql select queryDarryle Steplight13 Jul
            • Re: mysql select queryTianJing13 Jul
              • Re: mysql select queryJohnny Withers13 Jul
                • Re: mysql select queryTianJing13 Jul
                  • Re: mysql select queryJohnny Withers13 Jul
                    • Re: mysql select queryTianJing13 Jul
                      • Re: mysql select queryJohnny Withers13 Jul
                        • Re: mysql select queryTianJing14 Jul