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.li...@tamaratemple.com>
wrote:
> Jason Pruim <li...@pruimphotography.com> 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
>
>
