Server side processing with millions of rows

jborrajo

Hi,

I want to use DataTables with a table that has several million rows.

The problem is about how server side searches are fired.

DataTables does a new search on each onkeyup event on the filter text box.

This is no good on very big server side tables, since each search will take several seconds to complete.

I think a search button woulb be required for this scenario, but I see no way to do that using DataTables API.

Another option could be firing up searches every few seconds but only when there are changes on the filter text box since last search.

What do you think?

Thank you and great tool!

Javier

allan

This plug-in will help out - it can be customised as well if you want to refine it to require a certain number of characters etc: http://datatables.net/plug-ins/api#fnSetFilteringDelay

Allan

jborrajo

That wa fast!

Works fine, thank you Allan