I'm having some performance issues with KoolPHP Pivot tables. Here is the scenario:
- I have a MySQL table with ~70.000 items
- For columns in the pivot table I'm using only one column (this column is indexed; cardinality 12)
- For rows in the pivot table I am using 5 columns from the given table (all columns are indexed; cardinalities are from 8 to 800)
The initial load takes around 1-3sec, when I expand an item the AJAX request takes around 6sec to load, when I expand further the next one takes around 15sec etc . . . These load times seem awfully long . . . any ideas why this might be taking so long? . . or any suggestions on how I can optimize this?