[solved] loading time / list of records

[trip]

Joomla 3.3.6
Fabrik 3.2

Hi Guys
we have a table with about 20.000 records.
When accessing the list, its very slow to load.

We have one left join on this table.
All other list views load normally, except this one.

We would appreciate some insight into checking why this is slow. I cannot imagine why 20.000 records would take so long.

details to the backend have been supplied.

Matthew

 

[rob]

I dealt with this one via the support chat.
For future ref, for some reason when fabrik saved the join it didn't create the index on the joined tables fk.
Manually adding that fixed the issue

 

[trip]

Thanks Rob.