Filters don't work when Server Side processing is enabled on a SQL based data source?
I need to enable server side processing of a SQL table which will become 20,000+ rows over time.
At the moment the table is +-100 rows and already takes too long to load on a page refresh. For this reason I need to enable server side processing to limit the number of rows loaded on page load until a user applies filters.
Why does Powerful Filters not work with Server Side processing? What are my options to allow users the Filter functionality and to have data retrieved based on Filter parameters rather than pulling all rows in the SQL data table?
The Powerful Filters add-on only provides you with the ability to use cascade filtering and to hide the table before filtering is applied. All other filtering functionalities are already included in wpDataTables.
The speed of a page depends on a lot of factors, not only wpDataTables. If you're having issues with the loading of the table with 100 rows, you may have too many active components on the page, too much data (images, videos, etc), or you're using a slow server, or a bad hosting plan.
You can check out this table which consists of 2,560,000 entries. At the bottom of the table, you'll see the filters. Feel free to use them and see how the plugin works with MySQL query-based tables, on a stable server.
Can you check with your hosting provider and ask how much memory is allocated to your website?
Previously I did a few tests on a complex SQL query I used as a data source for my table. Whenever I enabled Server Side Processing, column filters would not return any rows for my table...
Your response prompted me to try configuring my SQL script as a SQL view, and now with Server Side Processing enabled my filters work as expected.
Thanks for getting back to me - This has been a great help and I'm very relieved that there isn't a limitation as assumed at first.
Complex SQL query is often correctly displayed in a table, but the parser that we use can't handle it correctly, so filtering, sorting, and search may not work correctly or at all. It's great that you thought of using a view and I apologize for not mentioning it in my initial response.
Filters don't work when Server Side processing is enabled on a SQL based data source?
I need to enable server side processing of a SQL table which will become 20,000+ rows over time.
At the moment the table is +-100 rows and already takes too long to load on a page refresh. For this reason I need to enable server side processing to limit the number of rows loaded on page load until a user applies filters.
Why does Powerful Filters not work with Server Side processing? What are my options to allow users the Filter functionality and to have data retrieved based on Filter parameters rather than pulling all rows in the SQL data table?
Hello Rudi.
The Powerful Filters add-on only provides you with the ability to use cascade filtering and to hide the table before filtering is applied. All other filtering functionalities are already included in wpDataTables.
The speed of a page depends on a lot of factors, not only wpDataTables. If you're having issues with the loading of the table with 100 rows, you may have too many active components on the page, too much data (images, videos, etc), or you're using a slow server, or a bad hosting plan.
You can check out this table which consists of 2,560,000 entries. At the bottom of the table, you'll see the filters. Feel free to use them and see how the plugin works with MySQL query-based tables, on a stable server.
Can you check with your hosting provider and ask how much memory is allocated to your website?
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Thanks Aleksandar!
Previously I did a few tests on a complex SQL query I used as a data source for my table. Whenever I enabled Server Side Processing, column filters would not return any rows for my table...
Your response prompted me to try configuring my SQL script as a SQL view, and now with Server Side Processing enabled my filters work as expected.
Thanks for getting back to me - This has been a great help and I'm very relieved that there isn't a limitation as assumed at first.
I'm glad to have been of assistance, Rudi.
Complex SQL query is often correctly displayed in a table, but the parser that we use can't handle it correctly, so filtering, sorting, and search may not work correctly or at all. It's great that you thought of using a view and I apologize for not mentioning it in my initial response.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables