Handle 2,000,000 Millions of rows

auditweb

Hi,

i´m new to datatables so please have indulgence;-)

My problem is simple. I get my rows from an ajax call.
All fine - but all the rows(2,000,000) are shown on just one site of the table.
Also i can´t searching, filtering and the pagination also dosen´t work.
Strange - if i delete the 'serverSide' than all my rows are shown correctly(searching, filtering and the pagination working).

Thanks @all

allan

Server-side processing is absolutely the way to do it. Have you implemented server-side processing on the server? See the following documentation:

• http://datatables.net/manual/data#Processing-modes
• http://datatables.net/manual/server-side

Allan

onetwo

Try to use 'length'

auditweb

hi allan,

as i said - if i delete serverSide it works fine.
But if i use it, than the problems above are comig up

allan

Yes, and as I say, that suggests that you haven't correctly implemented server-side processing on the server, and I linked through to the documentation.

I'm afraid I can't offer any more help than that without a link to the page though, as I don't know what the specific error is. Can you please link to a test case (as per the forum rules).

Allan

auditweb

This is my code on the server side which is returned
(...)
object.put("draw", 3);
object.put("recordsTotal", rows);
object.put("recordsFiltered", rows);
object.put("data", back);
response.setContentType("application/json");
out.print(object);
(..)

But i have still the same issue

tangerine

I'm afraid I can't offer any more help than that without a link to the page though, as I don't know what the specific error is. Can you please link to a test case (as per the forum rules).

Allan

auditweb

ok here is my link:

http://148.251.42.116:8080/employee/

Note: First it´s freezing than all rows are shown

EDIT: Now i have set the LImit of the SQL-Statement to 100.
But still - all rows are shown on just one site - no filtering, no pagination

auditweb

I need the solution - PLEASE

crunchfactory

I see a comma at the end of "type" : "GET", that shouldn't be there on the last one... that might be killing it..

auditweb

no it wasn´t i have solved it anyway;)

auditweb

Ok now i have comment out the 'serverSide' mode.
Now it loads the records faster (349,858 records)
But if i want to use the searching field - all is stoping!