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?

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.