I created a views reports page with multiple field collections (10), I added the field collection in relationships in advanced option to get the fields inside the field collection. this works great I get all the data that I need. but here's the problem. If the page have the data on it, it takes time to load the page.
Example: If I have thousands of data in views reports page, it takes time to load the page, almost 1 minute(some times it keeps on loading). though I only display 10 items on each row using pagination/views lightpager but stills the page loading is slow,
My question: is how can I optimise my views reports page with multiple field collection relationships in my current setup, any suggestions will be appreciated.
Note: The data should always up to date. that's why I don't cache the views.