How to bind large number of model data into html table in mvc

Question

0.00/5 (No votes)

See more:

Dear All,

I am trying to bind the model data into html table in my mvc application and able to get the data in UI in fraction of seconds. But when the records are more than 25k, it takes 15-20 seconds to bind.

Below is my code :

cshtml :

HTML

<tbody id="faultydevice-container">
            @foreach (FaultHandlingReportFaultyDeviceDataViewModel device1 in Model.FaultyDevices)
            {
                <tr>
                    <td>
                        @device1.status
                    </td>
                    <td>
                        @device1.pointAddress
                    </td>
                    <td>
                        @device1.Description                       
                    </td>
                    <td>
                        @device1.eventTime
                    </td>
                    <td>
                        @device1.eventResetTime
                    </td>
                </tr>
            }
        </tbody>

Note : I am not using entity framework to get the data. Instead, just calling the stored procedure to bind the records into a list. i.e., using ORM

Can anyone please suggest the way to bind huge data into html table ?

Thanks in advance,

Posted 27-Oct-15 23:19pm

Raj.rcr

Updated 12-Nov-15 20:11pm

v7

Add a Solution

Comments

Krunal Rohit 28-Oct-15 5:24am

Do with Paging. Or rather use Grid.

-KR

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)

F-ES Sitecore · Answer 1 · 2015-10-27T23:23:00

Solution 1

Creating large tables is always going to be slow. If a user spent 3 seconds on each of your rows it would take 20 hours to process the whole table, so you are obviously generating a lot of meaningless data the user ignores. There is no fast way to do what you want to do, instead you should implement paging\filtering\searching so that users only see the data they are interested in, or if you must give them tens of thousands of rows they at least only see the first page if they're not interested in the rest.

Posted 27-Oct-15 23:23pm

F-ES Sitecore

Comments

Raj.rcr 30-Oct-15 3:49am

Hi.. Is there any other way without using paging\filtering\searching concepts ?

F-ES Sitecore 30-Oct-15 4:21am

Not really, no. You could make ths site responsive while it loads by maybe using ajax to download and add 100 rows at a time to stop everything being done in one hit, but it will still take a lot of time to render.