> From: joker_mosmos@xxxxxxxxxxx > To: phpster@xxxxxxxxx > Date: Tue, 29 Nov 2011 23:07:13 -0500 > CC: phildobbin@xxxxxxxxx; php-db@xxxxxxxxxxxxx > Subject: Re: Problem with mysql and php > > > > Le 2011-11-28 à 22:38, Bastien Koert <phpster@xxxxxxxxx> a écrit : > > > On Mon, Nov 28, 2011 at 9:19 PM, Phil Dobbin <phildobbin@xxxxxxxxx> > > wrote: > >> On 29/11/11 02:08, "Jason Pruim" <pruimj@xxxxxxxxx> 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 > >> > >> > > > > jason, > > > > Assuming you have indexes on the data properly, have you looked into > > the mysql settings to ensure that you have the ones for large or xl > > datasets? There are a number of settings for buffers and sort spaces > > that can tune the database for performance > > > > http://www.mysqlperformanceblog.com/2006/06/09/why-mysql-could-be-slow-with-large-tables/ > > > > Also, what kind of hard ware are you using? Does the db server have > > oodles (yeah that techie term) of RAM? > > > > Have you looked into creating views for each state? If the db has a > > fairly static dataset (only adding not much updating) then you create > > those views so that you are then doing a single select against a > > pre-processed dataset. > > > > More tuning can be done by sharding the data across different > > diskdrives to aid i/o. > > > > A great book on mysql performance is High Peformance MySQL > > http://www.amazon.com/dp/0596101716?tag=xaprb-20 which is chockful of > > great options and info about gaining performance. > > > > > > > > -- > > > > Bastien > > > > Cat, the other other white meat > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > You can try nosql :) > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > You can try nosql :)
