Jump to content

Ever split a 1:1 vs. 7 table?


This topic is 7099 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I know the drill ... Keep all Customer data within the Customer table, unless it is 1:n (one-to-many). But do you ever split a table just to make your life easier and the table more manageable?

Our current design in 7 is hitting the 300-field mark (before any calculations or globals) and, wading through it is already tiring. There are no two 'like' fields within it but I have already gathered a few logical groups, ie, Credit information containing bank info, credit rating, FedID, OwnerOfRecord, etc - 45 fields); or Business properties, ie, sq. ft of store, # of employees, EndCap requirements - another 30).

I see absolutely no problem or additional work to create these related records because, being a 1:1, I can simply place any non-key fields cross-layout anywhere I wish (with Allow Creation on) and a new record would be created if I enter any information. And NONE of these fields would ever contain more than one piece of information. And since 7 allows reaching up or down through all Table Occurrence Graphs, it shouldn't matter, right?

30% of our Customers will have nothing in the Credit section anyway so splitting would decrease file size a bit. And I feel more free in 7, not worrying about external files and additional network protections; and knowing I can easily access the data again. Before I split this and make our lives (hopefully easier), are there additional reasons for keeping it together in 7? Benefits I might lose (or just might be more difficult) if I split them? I appreciate any thoughts on it...


Link to comment
Share on other sites

This topic is 7099 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.