Re: [PHP-DB] Problem with mysql and php

2011-11-28 Thread Phil Dobbin
On 29/11/11 01:38, 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

Re: [PHP-DB] Problem with mysql and php

2011-11-28 Thread Phil Dobbin
On 29/11/11 02:08, Jason Pruim pru...@gmail.com wrote: PostgreSQL? ;-)... In all seriousness... Would it help or change it in anyway? :) I am free to use what I want (I believe) on this project... It's well worth looking into. Postgres can handle far bigger db's much quicker than MySQL