A single DB table with 500,000 records is not a problem, as long as you're using a decent DB engine. I've used both Postgres and MySQL for tables with several million records. Just make sure that you use the DB's optimisation for large tables (eg. indexes, etc.)
On Wed, Aug 26, 2009 at 7:23 PM, DigitalDude<e.blumsten...@googlemail.com> wrote: > > Hey, > > I'm wondering if it would be possible to build up a small a medium > social network, just testwise, with CakePHP. > > Let's say we would have approx 50.000 users and the could connect to > each other, could Cake and the DB handle those masses of users and > information? > > How would it be pissible to save the users relations? A > hasAndBelongsToMany-table where the relationships are stored would > take up to let's say 500.000 records in a DB table, is this possible > with only ONE database? > > Although this is quite a theoretical question here, I'd be interested > in your opinions and suggestons. > > Regards, > > DD > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---