addition of column into the datatable..

Question

0.00/5 (No votes)

See more:

According to the current status of my program...a new column is get added to the existing table in every week....for a log term scenario ,is it a goood practice or not?

Posted 30-May-13 22:42pm

geo thomas

Add a Solution

Comments

gvprabu 31-May-13 4:51am

give some more details about your problem.

geo thomas 31-May-13 4:56am

it is a perfomance analysing program..employee's perfomance is calulated by comapring many qualities...the perfomance check is done every week of a month ..in such case i may need to create a new colum to a table every week...so ma data table gets bigger is it is a good practice

gvprabu 31-May-13 5:05am

u can use new table with following columns empID, finYear, finWeek, performanceDtls....
and JOIN with main table based on EmpID.

Why you want to add the New Column every week?

geo thomas 31-May-13 5:11am

in this case the second perfomance evaluation replace the old record rit?
i want to keep all the records.

gvprabu 31-May-13 5:07am

data in ROW then u can do reports, In case all your data in COLUMN like 52 column for one year, then later sure you can face many problems doing any reports or fetching details for one year like this...

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Osman24 · Answer 1 · 2013-05-30T22:54:00

Solution 1

1024 columns per non-wide table, 30,000 for wide tables, these are the limitations for mssql, 4096 for mysql. I think this is not a good solution for long term. if everyting goes ok, your program will crash approximately 4 year.

Posted 30-May-13 22:54pm

Osman24

Comments

geo thomas 31-May-13 5:08am

tnk u

geo thomas 31-May-13 5:14am

maximum how many colums can be added to a database?

Osman24 31-May-13 7:04am

It is also about size and other limitations. Here is the answer: http://msdn.microsoft.com/en-us/library/ms143432.aspx I think you are using MSSQL