due to huge data fetching query in asp.net making slow

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

, +

Hello

Due to huge data fetching query of sql server in asp.net program making slow.

Please help me in details what should i use in sql server.

Thanks.

Posted 7-Feb-12 22:11pm

JBSAHU

Add a Solution

Comments

zyck 8-Feb-12 4:13am

how many records do you Retrieve in your Database?
can you post your sql code

Aniket Yadav 8-Feb-12 4:16am

Yes ZYCK Is Correct, Please Post Your Sample Code So That We Can Figure Out What And Where The Problem Lies.

Al Moje 8-Feb-12 4:19am

Is your problem evolving slowness at page index change?

Sergey Alexandrovich Kryukov 8-Feb-12 4:19am

Not a question -- yet. You can use "Improve question".
--SA

Herman<T>.Instance 8-Feb-12 4:22am

start using async db calling

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)

OriginalGriff · Answer 1 · 2012-02-07T22:25:00

Without much better information, it is not possible to be precise, but there are general recommendations:

If it is the data fetching that is slowing things down, then there is a simple solution: fetch less data.

If you are fetching all fields

SQL

SELECT * FROM ...

Then don't - select only the fields you need for the row.

SQL

SELECT Username, email FROM ...

If your database contains images for example, this can save a considerable amount of time.

If you are fetching a lot of records at one time, then don't: filter your records so you only retrieve those you need - presenting the user with lots of records is both slow and a waste of your time and theirs - how do you expect them to find the data they are interested in, if it is a single row out of 10,000?

Finally, if you are processing the data to extract some specific info from it, it may be worth moving the processing into a Stored Procedure so that the information ios condensed at the SQL Server instead of transferred and then condensed. And example would be transferring all teh rows so that you can add the total, rather than using the SQL SUM function and returning just the single final value./