Hi - the problem with the table partitioning you describe is a) data repetition (see normalization) - do you want to have two tables with similar info like first name, surname, etc? b) uniformity - how do I know how many people might be in the building at one time? Or male/female ratio? You'd have to join the tables to find out.
I don't think performance will be much an issue here (although I don't know anything about context). Some solutions: 1) Seperate out the shared info into another table, say, people - then the student table has a link to a person, as does a teacher, etc. 2) Abstract the difference, so they use one table in the DB but can appear to have different tables when necessary. Using a MySQL view or a single table inheritence technique (google is your friend!) could manage this. On Jun 12, 2:20 am, Cheeze <[EMAIL PROTECTED]> wrote: > Hi, > > I'm planning for a project for schools. As you might imagine there are > mainly two groups of users - Students and Teachers. > > I'm at the stage of designing the database tables and was wondering if > having separate tables for students and teachers might yield better > performance than having a single table with a column indicating the > user as a student/teacher. > > I'm thinking that having separate tables might improve concurrency > when many students and teachers are using the site at once (think read/ > write locks) since they are using different tables. > > Granted, I'm not writing the app for millions of users, but if it > helps to improve the performance, it'll translate to better user > experience. And I guess there are others out there who are curious > about it as well. > > Thanks. > > P.S. Kudos to the Cake team for coming up with RC1 of 1.2. Yet another > great release. Thanks to all who made this possible! --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
