Can Client Side Paging increase performance while fetching records?

Question

0.00/5 (No votes)

See more:

Hi All,

I am new on data paging in MVC, i have a page which renders 5000 records it thrown an error which is given below:-

System.Data.SqlClient.SqlException (0x80131904): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

to resolve this problem i want to apply paging so i just want to know can i apply client side paging to resolve my problem or i have to apply server side paging?

Thanks in advance.

Posted 2-Jun-15 2:25am

Tilak Rathour

Updated 2-Jun-15 2:26am

v2

Add a Solution

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)

Praveen Kumar Upadhyay · Answer 1 · 2015-06-02T03:28:00

First of all you need to understand few things.

1) Any query which is bringing 1 record will also be able to bring 5000 records from the database. If the count is more than a lac or so then might need an optimization but still I don't think and as per my thinking if it is fetching more than 5 lacs rows then we might need to optimize it. It totally depends upon the server configuration.

Check your query if with putting a row limit your query is able to fetch the record without a timeout, let's say check with 5 rows or so. If yes then your query need to optimize and if not then it will very easily able to fetch 5000 record also.

2) Now coming to your second question that handling huge records at front-end level will help or not by using paging concept.
Answer : It depends, if your query is costly and taking time to fetch data then paging will decrease your database performance and even will make user to wait every time he clicks on page change button.
If your query is not costly then you can use paging concept as loading so much record at once on the browser will make client system(browser) very slow.

I hope I was able to answer your question.