Also if you are planing to use AuthComponent having one table will make it easier.
On Wed, Jun 11, 2008 at 11:14 PM, the_woodsman <[EMAIL PROTECTED]> wrote: > > 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 -~----------~----~----~----~------~----~------~--~---
