Try running this : http://mysqltuner.pl/mysqltuner.pl If the server has been up for over 24hrs it gives a lot of good insight and things to try tuning wise as a starting point. It'll uncover a lot of common configuration issues or MySQL server level bottlenecks. -Dan (apologizes for the top post from the mobile) On Nov 29, 2011 5:33 PM, "Tamara Temple" <tamouse.lists@xxxxxxxxxxxxxxxx> wrote: > Jason Pruim <lists@xxxxxxxxxxxxxxxxxxxx> wrote: > > > Given the following 2 queries: > > > > "SELECT DISTINCT areacode FROM main WHERE state = > '{$query_exploded[0]}'"; > > > > "SELECT DISTINCT areacode FROM main"; > > > > The second displays ALOT faster.... Like by minutes... the first one is > what I really want though.... Currently working with a dataset of 89 > million records, will be expanding that to many many more times that... To > the tune of possibly a couple billion records... > > > > Any ideas? :) > > make state an index into the table. > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >
