hi,
i've been asked to design a for a new web-based system which stores lots of data on
it's members. There are currently about 500,000 member records.
the problem is that i have to store at least 248 pieces of information on each user.
i've made the system as relational as possible so that for each user record, i am only
storing integers, for the most part tinyints and smallints.
Is there a limit on the number of fields per record. I can easily see this new system
requiring 300 fields(columns). what are the consequences for making a table with so
many columns. this table will be updated very frequently - will access time degrade
severely even though i use mainly ints in this table?
thanks for your help.
anna