Cached view gets really slow
3 August, 2011
I just upgraded to YF5.2 and defined a view which for wich I created a cache copy to a in-memory columnar db. Once I select the cache DataSource and press the "Save" button to confirm, everyting starts to be very slow with this view (even before populating the cache).
Just trying to edit the view hangs forever and I see my source database process up to 99% cpu.
With previous YF versions, this used to work fine (obviously the data populating thing was long, which is normal) but now any time I try to cache a view with some volume of data, it's really slow. Any clue?
Just trying to edit the view hangs forever and I see my source database process up to 99% cpu.
With previous YF versions, this used to work fine (obviously the data populating thing was long, which is normal) but now any time I try to cache a view with some volume of data, it's really slow. Any clue?
Hi Hector,
What database are you caching?
Could you repeat the above and then send all of the log files from Yellowfin/appserver/logs to support@yellowfin.com.au
Also could you open new tabs while the hanging is occurring and also send us the outputs from the info_threads.jsp page E.g. http://localhost:80/info_threads.jsp and the info.jsp page E.g. http://localhost:80/info.jsp
Regards,
Steven
What database are you caching?
Could you repeat the above and then send all of the log files from Yellowfin/appserver/logs to support@yellowfin.com.au
Also could you open new tabs while the hanging is occurring and also send us the outputs from the info_threads.jsp page E.g. http://localhost:80/info_threads.jsp and the info.jsp page E.g. http://localhost:80/info.jsp
Regards,
Steven
Many thanks Steven, but I think I solved on myself: I realised that all my joins where set to INNER instead of LEFT (this happened anytime after the upgrade). Just deleting and redefinig the table joins in the right way solved the problem.
Now everything works as it used.
Now everything works as it used.