searching over 300 000 facts to lazy

onetwo

Hello,

my table contains about 300.000 datas.However, the search is to lazy.
How can i speed up this problem?
No link - just a questions;)

merci - thanks ...

tangerine

This FAQ should help: http://datatables.net/faqs#speed

onetwo

Thanks @tangerine,

can u tell me where is the 'spped up' for the 'millions of rows'?
Is it also the 'bDeferRender'?

allan

Server-side processing for millions of rows.

Allan

onetwo

@allan,

that´s not the problem - i have 350 000 in my table(later then 2.Mill). The problem that i have is that when i start tipping letter into the search field - the table is freezing for a while.
But if i load about 1000 datas in my table (server side) then it goes fine.

So the problem is just the bulk of data.
So i can´t link to a table, because the problem is only if i load data with server side and ajax.

Thanks

allan

If you use DataTables 1.10 you'll find that the server-side processing mode has a small buffer built in for searching so it doesn't make a request on every key press. If you are using 1.9- you can use the fnSetFilterDelay plug-in on the API plug-ins page.

However, you very certainly want to use server-side processing if you are using millions of rows.

Allan