Searching sorting on data loaded using server side scripting

sonalithakkar07

Hi

I am new to used datatables.

I have query that if i have 1000000 records loaded in datatable using server side processing.

But its take time for searching. Also if array pass to the datatable having data from two queries then searching is not possible on both queries. And if query has aggregate function then sorting is not possible.

Please help me for the same.

Thanks in advance

allan

I'm afraid I don't really understand your question. Is the issue that your server-side processing script is too slow? You'd need to profile the script and database in that case to see where it can be made more performant (e.g. adding indexes).

Allan

sonalithakkar07

I have to covered 3 points

I am using server side processing.

1) If i have huge amount of data then it's take time to load searching of data.
2) If i have two queries which send data to datatable so i want to perform searching on both queries
3) And if query has aggregate function then need to sort that column also.

colin

Hi @sonalithakkar07 ,

Yep, as Allan said, you just need to profile the database, add indexes where appropriate, standard DB management. It's a reasonable sized dataset, so you need to ensure you're using a sensible, tuned database.

Cheers,

Colin