Question about performance
I 've created a database with clients (master table) ---- appointments(child) (some other tables are present, but these 2 are the major ones) . Each appointment includes about 500 possible fields, most of which are either 0 or 1. With growing number of clients (i.e 1000), this should mean about 500,000 possible fields. However, in the vast majority of appointments, not more than 20-30 fields are filled in. The rest are null.
My question is : do the null fields affect database performance to the same degree as filled-in fields? Should i be concerned about the structure and future performance of the database?