Subject | singleton table with many fields |
---|---|
Author | thp_pkmi |
Post date | 2013-07-16T03:03:13Z |
Hi all,
I have a table that always contains 1 record and have about 50 fields with various type. It's function is to store system parameters and is accessed very frequent from application and also from database triggers and stored procedures. Is it wise to utilize a singleton table like this, or is it better to implement a table with many records storing parameter name, type, and values ?
Thank you very much.
Regards,
Tjioe
I have a table that always contains 1 record and have about 50 fields with various type. It's function is to store system parameters and is accessed very frequent from application and also from database triggers and stored procedures. Is it wise to utilize a singleton table like this, or is it better to implement a table with many records storing parameter name, type, and values ?
Thank you very much.
Regards,
Tjioe