Subject | RE: [firebird-support] fb table limit question |
---|---|
Author | Bill Meaney |
Post date | 2006-03-06T22:29:50Z |
> one of my main concerns is the number of fields per record/row in FB.Your two comments about "newbie-ness" and "255 columns per row", beg the
> the BDE is limited to 255 and that is was too low for my app.
>
>
> thanks and sorry for the newbie-ness of the question.
question, "Have you reviewed the design of your tables for appropriate
normalization?" I've never seen a case where a table that has this many
columns couldn't be designed to be more efficient and less tedious in
application development. A table with this many columns often has repeating
column names with a sequencial suffix number. Such as:
KeyId
Name01
Address01
City01
State01
Zip01
Name02
Address02
City02
State02
Zip02
Name03
Address03
City03
State03
Zip03
or prefixed such as:
KeyId
MyName
MyAddress
MyCity
MyState
MyZip
HisName
HisAddress
HisCity
HisState
HisZip
HerName
HerAddress
HerCity
HerState
HerZip
If this is the case, you may want to post the table structure here for some
alternative ideas.
Bill Meaney