i was successfully able to handle tables with more than 2000000 records "yes, above 2 million records!" with CakePHP and with a very acceptable performance and speed, the first thing that you should be thinking of is sharding the database into smaller chunks "DBs", second thing is enabling "memcached" to reduce DB access "specially reducing the master DB hits", thirdly enable APC or whatever bytecode cacher you might be able to use "this will gain your web server a very good performance boost", and finally set the debug level for you cake app to "0" to cache the tables "DESC" operations. Taking all the above into consideration CakePHP can be a very powerful framework to handle huge databases!.
On Mon, Sep 21, 2009 at 8:50 PM, Miles J <mileswjohn...@gmail.com> wrote: > > Well how big is your table? I have tables with over 200,000+ rows and > it works just fine. > > > -- http://phpirate.net --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
