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

Absolutely the first thing I would do is an EXPLAIN on the slow query, and
work from the results of that. I'd hazard a guess that there might be
indexing problems.


David Robley

Insert inevitable trivial witticism of your choice.
Today is Pungenday, the 41st day of The Aftermath in the YOLD 3177. 

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to