Cascading Panes

Hazem123

Link to test case:
Debugger code (debug.datatables.net):
Error messages shown:
Description of problem:

I have a table of around 20K rows, 15 columns, and I tried using cascading search panes. It takes forever to load even with only two cascading panes. Is this an expected behaviour?

I did read on other posts of other techniques to solve this problem. However, I assumed 20K rows isn’t a lot to process.

allan

Are you using server-side processing? If not, then that might be the answer.

Cascade panes is always slow with half decent sided data sets unfortunately. If you link to your page I can profile it to see if there are any specific optimisations that can be made.

Allan

Hazem123

Hi Allan,

I don't load it the same way mentioned in the link you have provided as I am not using Editor version (Ajax). I simply load the data via php call to the database which returns around 17K records, between 10-15 columns.

I have uploaded an example on the two links below for testing purpose I have limited it to 10 Columns.

The first one is the normal searchPanes and the second is with cascading option:

1: https://www.thecavesa.com/admin/statistics.php
2: https://www.thecavesa.com/admin/statistics_cascade.php

Thank you Allan.