Server-side populated datatable with ajax filtering features
Server-side populated datatable with ajax filtering features
hacioglu
Posts: 1Questions: 0Answers: 0
Hi,
i am using datatable for the first time and i must say it is great.
I was populating a datatable via ajax call with a small amount of data and it is very easy to make searches against it, just because the filter is being applied to all columns simultaneously.
Now i want to have the same filter options in a table, for which the data is being generated server-side. I have a table in my db with 30.000 rows. I tried it with an ajax call. It took about 5 seconds till the table generating process completed fully, and for my employer, this is a no-go.
I tried to populate the table with fnAddData and multiple ajax calls at the same time, which returned smaller pieces of the whole data. That made as expected no difference in speed.
I looked at the example on http://www.datatables.net/release-datatables/examples/server_side/server_side.html
But the filter option there is very poor as mentioned there.
[quote]
Filtering
* NOTE this does not match the built-in DataTables filtering which does it
* word by word on any field. It's possible to do here, but concerned about efficiency
* on very large tables, and MySQL's regex functionality is very limited
[/quote]
For example i cant search for gecko and firefox at the same time. My question is how to adress this problem with Mysql and Apache Webserver.
(Sorry for my poor english)
Thank you
i am using datatable for the first time and i must say it is great.
I was populating a datatable via ajax call with a small amount of data and it is very easy to make searches against it, just because the filter is being applied to all columns simultaneously.
Now i want to have the same filter options in a table, for which the data is being generated server-side. I have a table in my db with 30.000 rows. I tried it with an ajax call. It took about 5 seconds till the table generating process completed fully, and for my employer, this is a no-go.
I tried to populate the table with fnAddData and multiple ajax calls at the same time, which returned smaller pieces of the whole data. That made as expected no difference in speed.
I looked at the example on http://www.datatables.net/release-datatables/examples/server_side/server_side.html
But the filter option there is very poor as mentioned there.
[quote]
Filtering
* NOTE this does not match the built-in DataTables filtering which does it
* word by word on any field. It's possible to do here, but concerned about efficiency
* on very large tables, and MySQL's regex functionality is very limited
[/quote]
For example i cant search for gecko and firefox at the same time. My question is how to adress this problem with Mysql and Apache Webserver.
(Sorry for my poor english)
Thank you
This discussion has been closed.