Large Dataset

andmattia

Hi

any experience in a dataset like 50/20.000 rows ?

tangerine

One of my tables has 170,000 rows. What is your question?

allan

20 million here.

andmattia

My question is about performance.

If i try to send to my client a table with 15.000 rows with 10 cols it's about 1,2/1,5 Mb and my client still unresponsive for a lot of time.

How have youe resolve this issue?

allan

Use server-side processing. See the FAQs :-).

Allan

andmattia

Thanks for ur answer but not solve my problem. Supposed that you need to see all data on single page. To do that i put to 1.000.000 the page rows size and my server send me 15.000 rows (more or less 1.5mb) if I reduce tha page dimension I don't have problem.

So probably my approch is worong because I need to do that to see the total row on footer and to do that I use a js function but if I render a partial data total is only of the page and not global.

Is possible to do in different way?

allan

Yes, if you are using server-side processing it would need to do the summation of the data and you would use drawCallback to insert the column totals into the footer cells.

Allan

andmattia

thks Allan can you provide a simple example to do that?

allan

Certainly - the Quick Support 60 option would cover that.

Allan

cb1

Allen will datatables work ok in an ASP.NET 4.5 MVC EF application. I have a large dataset (100,000 records)drawn from a SQL Server database but handled as virtual classes via Entity Framework. want to be able to scroll hz/vert and virtually thru the viewport.

Do you have a runtime and/or server side script example for that??

thanks,
Christie

allan

It will work just fine if you implement the server-side processing protocol described in the manual. I don't have an example using EF that I can send, sorry.

Allan