So, i'm starting a project that has the potential to be a lot larger than anything else that i've done and I need some advice from the experienced...here's the basics...
Users log in to a web site...
users belong to a company->companies have projects->projects have docs, etc...
previuously all this information had been in one database separtated into tables...
so if I have 50 companies on the website and each company has 20 projects and each project has 100 documents...my project documents table starts to get huge (100,000 rows). Would it be wise to separate each company into it's own database? Does this make sense or am I just used to working at too small of a scale? Thanks.
