Posted: Tue Aug 16, 2005 12:51 pm
I don't think the single table versus multiple tables is a scaleability issue. With proper views/stored procedures or even just a single point access from PHP you can completely hide the multi-table layout, plus each table is more aligned with its use (no generic parameter coluumns and said columns can refer to appropriate other tables where needed.)
I think if I were forced to work under the common versions of MySQL, I'd might agree with you, though, so your advice might be right here. (I typically only use PostGreSQL so I'm more familiar with its capabilities)
I think if I were forced to work under the common versions of MySQL, I'd might agree with you, though, so your advice might be right here. (I typically only use PostGreSQL so I'm more familiar with its capabilities)