1,105,271 Community Members

what is a recommended maximum column count per table

Member Avatar
dualzNZ
Junior Poster in Training
56 posts since Jan 2012
Reputation Points: 18 [?]
Q&As Helped to Solve: 1 [?]
Skill Endorsements: 0 [?]
 
0
 

Hi all
I am currently working on a Battlefield player / server statistics application that i have written in C#.
I am storing RAW player / server data in a table at the moment.

My question is what is a recommended maximum columns per table as this statistical data which will be used in a formula to check players against the database for probible cheater analisys.

at this stage my table is looking at around 400 columns.
Would it be wise for me to use joins and just add them to specific tables and just call on them when setting up my forumla array?

thanks

Member Avatar
pritaeas
mod_pritaeas
11,291 posts since Jul 2006
Reputation Points: 1,420 [?]
Q&As Helped to Solve: 1,832 [?]
Skill Endorsements: 155 [?]
Moderator
Featured
Sponsor
 
0
 

If some columns are used often, and other columns only for cheater analysis, dividing and joining them when needed is the logical choice. You can always create a view to simplify your client-side query.

Member Avatar
dualzNZ
Junior Poster in Training
56 posts since Jan 2012
Reputation Points: 18 [?]
Q&As Helped to Solve: 1 [?]
Skill Endorsements: 0 [?]
 
0
 

thanks for the reply, i have gone iwth just splitting the data into 3 tables to lower the insert / update size and time.

and just creating small query to gather information i need to gather the cheater analysis formula.

thanks for your reply.

Question Answered as of 1 Year Ago by pritaeas
Member Avatar
pixelsoul
Posting Shark
918 posts since Feb 2011
Reputation Points: 174 [?]
Q&As Helped to Solve: 147 [?]
Skill Endorsements: 25 [?]
 
0
 

It is always a best practice to split data into many different tables rather than having fewer real large tables.

Member Avatar
pritaeas
mod_pritaeas
11,291 posts since Jul 2006
Reputation Points: 1,420 [?]
Q&As Helped to Solve: 1,832 [?]
Skill Endorsements: 155 [?]
Moderator
Featured
Sponsor
 
0
 

It is always

No, not always. Often, yes.

You
This question has already been solved: Start a new discussion instead
Post:
Start New Discussion
View similar articles that have also been tagged: