Re: [PHP-DB] Problem with mysql and php
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
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? :)
PostgreSQL?
;-)...
Cheers,
Phil...
--
Nothing to see here... move along, move along
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Problem with mysql and php
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 but the downside is that it's a very steep learning curve after coming from mysql. It's relatively easy to install there are the drivers of course for PHP but it'll take up a lot of your time to learn it to the extent of being confident with it in my experience. Good luck, Cheers, Phil... -- Nothing to see here... move along, move along -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
