[thelist] assistance designing schema
r937
rudy at r937.com
Thu Jan 7 22:28:06 CST 2010
jeremy, any time you store meta-data (in your case, column names), you have
a very fragile design that is just begging for trouble
as well, any time you store multiple similar columns with suffixes like 01,
02, 03, etc., you are letting yourself in for complex queries that have very
little chance of being efficient
i would not attempt to implement "generality" where different users can
specify different column contents
insist up front that they identify and specify their information
requirements up front, then design a static schema
you'll save yourself gobs of coding and a world of hurt
rudy
http://simply-sql.com/
More information about the thelist
mailing list