News for hackers. Stuff that matters.
Re:Ask HN: Open Source apps with lots of database tables? by DanielBMarkham on Friday November 13, 2009 @02:33PM (#940596)
Depends on how the data model got created.

If there was sufficient refactoring, you should be able to run most enterprises on a small-ish number of tables. Say 100-200 (not including lookups) I'd almost bet that you could go <100, but I'll hedge my bets a bit.

If you don't refactor, and most enterprises don't, then yes, you can run easily into the 1500-3000+ range. You can also get this big if you buy a one-size-fits-all data model, which has to be God's punishment to mankind for being able to draw boxes and lines. You can also grow fast in a hurry if you have a team who love "patterns" and are not afraid to plop them in everywhere.

Most enterprise problem domains do not require anywhere near the number of tables they use to do their business.

Re:Ask HN: Open Source apps with lots of database tables? by towndrunk on Friday November 13, 2009 @02:45PM (#940632)
Yes. I can attest to that... my enterprise day job product has 1395 tables and 2286 views. It's a real mess actually.