Subject | one record and many fields or two fields and many records? |
---|---|
Author | emb_blaster |
Post date | 2008-10-22T17:39:37Z |
I thinking in use a table to record software configuration (like
*.ini files). But I wish to know... what is the best Create a Table
with many columns or a table with two columns and many records?
Example
CREATE TABLE CONFIG (
"SPLASH_SCREEN" BOOL,
"DEFAULT_USER_NAME" BOOL,
"ANOTHER_CONFIG_TAG" BOOL,
"YET_ANOTHER_CONFIG_TAG" BOOL
.........
"many_CONFIG_TAGs_later" BOOL)
OR
CREATE TABLE CONFIG (
"CONFIG_TAG_DESCRIPTION" VARCHAR(..)
"CONFIG_TAG_VALUE" BOOL)
I think that example 1 is more fast for a select, but example two
are much more easy for mainteanence (that´s the word? sorry the english..)
there´s a best choice in this case?
many thanks
*.ini files). But I wish to know... what is the best Create a Table
with many columns or a table with two columns and many records?
Example
CREATE TABLE CONFIG (
"SPLASH_SCREEN" BOOL,
"DEFAULT_USER_NAME" BOOL,
"ANOTHER_CONFIG_TAG" BOOL,
"YET_ANOTHER_CONFIG_TAG" BOOL
.........
"many_CONFIG_TAGs_later" BOOL)
OR
CREATE TABLE CONFIG (
"CONFIG_TAG_DESCRIPTION" VARCHAR(..)
"CONFIG_TAG_VALUE" BOOL)
I think that example 1 is more fast for a select, but example two
are much more easy for mainteanence (that´s the word? sorry the english..)
there´s a best choice in this case?
many thanks