If you use MySQL, even millions of records in table is not a problem while there are few columns, all of them are fixed (ints, chars) and you have good indexes. If you use other RDBMS, check out how can you optimize such table there. I am sure that any serious RDBMS also work fine with such table.
Add/delete from tables is also not a problem at all. Just use associations to keep tables consistent. On Oct 10, 12:26 am, Vijay Pandey <[email protected]> wrote: > Hi Dr. Loboto ! > > Thank you for responding... > > I could have done that...but the foremost problem is that there will > be more than 10000 individual users to be added to the table however > in other two tables there will be really very few users (less than > 10000 even in next 5 years). Secondly, individuals will be deleted > after a centain period of time....but no other user will ever be > deleted. > > Is keeping one table for users is the only solution? or are there some > other ways? > > Looking forward to your suggestion. > > Regards, > > Vijai Pandey --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
