Is there Performance Issue for Database Table with multiple Columns containing null value?

Question

0.00/5 (No votes)

See more:

What would be the impact if i design a database table with 10 columns all varchar(1000) but not all columns will have values?

This table will serve as my audittable for several tables.

Posted 17-Jan-13 18:57pm

Jephunneh Malazarte

Add a Solution

Comments

Sergey Alexandrovich Kryukov 18-Jan-13 1:32am

Well, what would be the alternative?
—SA

2 solutions

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)

Sergey Alexandrovich Kryukov · Accepted Answer · 2013-01-17T19:33:00

Solution 2

Please see my comment to the question. It depends what you want to compare this decision with. Anyway, I cannot imagine more efficient solution than when you actually using those null values. You hardly can go wrong with them.

—SA

Posted 17-Jan-13 19:33pm

Sergey Alexandrovich Kryukov

Updated 17-Jan-13 19:34pm

v2

Comments

Jephunneh Malazarte 18-Jan-13 4:20am

thanks SA I thought that when using varchar and assigned null value the actual size declared in the column will still be utilized. I am quite confuse at that time because the deadline of the project is drawing near.. with your comment and the comment from the other guys it give me confidence.. thanks again...

Sergey Alexandrovich Kryukov 18-Jan-13 12:46pm

You are very welcome.
Good luck, call again.
—SA

Jibesh · Accepted Answer · 2013-01-17T20:07:00

Solution 3

there is no performance issue in using VARCHAR. the space utilized is only for the length of the data stored in the column and not whole 1000.

you can also read other performance tips here[^]

Posted 17-Jan-13 20:07pm

Jibesh

Comments

Jephunneh Malazarte 18-Jan-13 4:18am

thanks... i am also able to get the actual comparison between char and varchar.. thanks jibesh..