Hi there,

I have a table that selects data from a complex view on a mysql database. The query takes arount 1.5 s to execute. On this table are various filters. These filters are mostly on columns that is configured with a foreign key, so the foreign key specify all the possible values that the column may contain. The filters are also configured as multi-select strings.

The problem that I have is that as soon as the filter is multi-select, it is seen in the code as a rangeslider. The code then re-run the whole view to find the min and max value:

wpdatatables/source/class.wpdatacolumn.php line 1012

      if ($this->getRangeSlider() === 1 && $this->getParentTable()->serverSide()) {
            $jsFilterDef->minValue = $this->getColumnMinValue();
            $jsFilterDef->maxValue =  $this->getColumnMaxValue();
        }

Having 10+ multselect filters - this view (which takes 1.5sec to execute) are queries 10+ times and it takes almost 50 sec to render the table (I also have inline editing) so each query are executed twice.

By commenting out the following two lines, I could cut out 30 seconds in rendering time and the filters are still perfect.

$jsFilterDef->minValue = $this->getColumnMinValue();
 $jsFilterDef->maxValue =  $this->getColumnMaxValue();

The problem that I have is that with each update on the plugin, I will have to look for these two lines again to speed up the table rendering time.

My questions are:

1) Why are multiselect strings considered rangesliders?

2) If it HAS to be rangsliders, why is the foreign key set-up not used to get the min and max value (which will be much faster)

3) Can there be an option in the set-up of the filtering to be a mult-select string without rangesliding

Thank you very much, I'm satisfied that I could assist other users in my position. We can close this issue - I will watch the updates like a hawk.. ;-)