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