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

Reply via email to