Slow in fetching datas in ms sql server 2008

Question

0.00/5 (No votes)

See more:

Hi Frnds,
I am working on ASP .net Project which helps to take online test.I have added questions to database in byte format.When i fetching questions from database its taking more time.for particular subject 1000 questions is there.When i select subject and click show i am binding questions in gridview.I am given paging per page 10.But its taking more than 2 mins to bind.I am using Stored Procedures for fetching.Please tell me quick way to get questions.Questions contain images also.So memory is more.

Posted 10-Oct-13 20:34pm

itsureshuk

Add a Solution

Comments

M Rayhan 11-Oct-13 2:49am

Did you use pagination in the stored procedure? or in the front end?

itsureshuk 11-Oct-13 3:30am

in front end,Gridview only i used paging.not in Stored Procedure.How to use in gridview

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)

thatraja · Accepted Answer · 2013-10-10T21:28:00

There're lot of reasons for slow issues in database.
And you didn't include the stored procedure in your question, so without seeing that we can't spot the issue quickly. Here some way to optimize things.
SQL Server DO's and DONT's[^]
Top 10 steps to optimize data access in SQL Server: Part I (use indexing)[^]
Top 10 steps to optimize data access in SQL Server: Part II (Re-factor TSQL and apply best practices)[^]
Top 10 steps to optimize data access in SQL Server: Part III (Apply advanced indexing and denormalization)[^]
Top 10 steps to optimize data access in SQL Server: Part IV (Diagnose database performance problems)[^]
Top 10 steps to optimize data access in SQL Server: Part V (Optimize database files and apply partitioning)[^]

M Rayhan · Accepted Answer · 2013-10-10T20:52:00

Solution 1

If you did not use pagination in stored procedure then use pagination in the sp

See here Custom Pagination[^]

Custom SEO friendly pagination[^]

Posted 10-Oct-13 20:52pm

M Rayhan