Run Store Procedure in Asp.net

Question

0.00/5 (No votes)

See more:

I have table which contain 1000 records in sql server Database,

if it is taking 15 second to run a select a command and bind it's record in Gridview on page load event.

so is there any way to reduce this 15 second to 2 second for aboce situation

Posted 29-Sep-11 3:51am

Surendra Tarai

Add a Solution

5 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)

sravani.v · Answer 1 · 2011-09-29T18:45:00

Solution 5

You can Use Sql paging to solve this problem

Posted 29-Sep-11 18:45pm

sravani.v

Justin Porteous · Answer 2 · 2011-09-29T03:52:00

Solution 1

use pagination.
http://msdn.microsoft.com/en-us/library/aa479347.aspx[^]

Posted 29-Sep-11 3:52am

Justin Porteous

Updated 29-Sep-11 17:07pm

v2

Muralikrishna8811 · Answer 3 · 2011-09-29T04:01:00

Hi,

My suggestion for your requirement is

we cannot show entire 1000 records on single page.

I do my way for this situation like...

first I got 100 records from database and store into application variable

After that retrieve 101-200 records and then save in application variable.

if user wants more than that I just remove my first feteched results from application variable.

Make sure website don't waste time for retrieving data from database.

All the Best

FastEvo8 · Answer 4 · 2011-09-29T04:11:00

Solution 3

I would also check the execution plan and make sure that you are not missing an index and/or your SQL is efficient.
Is this a simple select?
Are you calculating totals?
There is no way that a SQL server should take 15 seconds to return 1000 records...

Posted 29-Sep-11 4:11am

FastEvo8

Updated 29-Sep-11 7:19am

v2

devildx2050 · Answer 5 · 2011-09-29T16:45:00

Solution 4

you can use data-pager or pagination to overcome this problem...
:)

Posted 29-Sep-11 16:45pm

devildx2050