Thank you very much Dr. Loboto, In fact, I am using Mysql for databases. Now this is clear.
thanks a lot for your time and help. Regards, Vijai Pandey On Oct 11, 8:59 am, "Dr. Loboto" <drlob...@gmail.com> wrote: > 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 <vijayh...@gmail.com> 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 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 -~----------~----~----~----~------~----~------~--~---
