What is the best approach to get record from SQL Server if table has about 40-50 columns?

Question

1.00/5 (1 vote)

See more:

I am using SQL Server to manager my database and I have several tables which have large number of columns about 40 to 50 columns each.
Now I want to get an specific record from the table using ASP.Net. I am using ADO.Net to get data from SQL Server and I know how can I fetch data but I am looking for some optimized approach to fetch data with large number of columns.

Posted 1-Aug-15 3:52am

Ajay_Patel

Add a Solution

Comments

PIEBALDconsult 1-Aug-15 11:08am

For 40 or more columns, you could try spraying the pipes with WD40. :D
But seriously, are you having performance issues? Or are you simply being paranoid that you might? Until you actually have isues, there's no reason to seek a solution. Just try it and see how it goes. And follow the advice in the two solutions given so far.

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)

Wendelius · Answer 1 · 2015-08-01T04:15:00

Not sure what problems would you foresee in having 40-50 columns. Depending on the application a table can have hundreds of columns and perform very well.

However as a rule of thumb few things you need to remember:

Never fetch all columns using *, name the columns you want to fetch.
Fetch only the columns you need.
Never do formatting on the database side, let the client application handle that.
Whenever possible fetch based on the key.
Remember to uniquely index the key, preferably using primary key and unique constraints when needed.
Never fetch more rows than needed.
If several rows are fetched, consider paging.

OriginalGriff · Answer 2 · 2015-08-01T04:16:00

If you are only using a limited number of the columns, then only retrieve the ones you want: i.e. don't use

SQL

SELECT * FROM MyTable WHERE ...

List only the columns you are interested in:

SQL

SELECT Column12, Column35 FROM MyTable WHERE ...

Other than that, tuning your WHERE clause to only return the rows you want is pretty much your only other optimisation!

What is the best approach to get record from SQL Server if table has about 40-50 columns?

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0