EPG Grid performace - Printable Version +- Kodi Community Forum (https://forum.kodi.tv) +-- Forum: Development (https://forum.kodi.tv/forumdisplay.php?fid=32) +--- Forum: Add-ons (https://forum.kodi.tv/forumdisplay.php?fid=26) +---- Forum: PVR (https://forum.kodi.tv/forumdisplay.php?fid=136) +---- Thread: EPG Grid performace (/showthread.php?tid=192673) |
EPG Grid performace - xxxnelly - 2014-04-19 Hi All, Does anyone have any thoughts on how we could improve the performance of the EPG Grid for slower machines. I have around 600 channels (using TVH) and opening the grid takes nearly 1 second on my Revo, I guess it would take seconds on a rpi. Its find on my laptop but thats pretty powerful. Any ideas, I have had a look at the code epg/GUIEPGGridContainer.cpp but not sure what the best approach is. Thanks Acer Revo 3700 19:49:08 T:140446351775616 DEBUG: UpdateItems completed successfully in 832 ms 19:49:10 T:140446351775616 DEBUG: UpdateItems completed successfully in 826 ms 19:49:13 T:140446351775616 DEBUG: UpdateItems completed successfully in 833 ms 19:49:17 T:140446351775616 DEBUG: UpdateItems completed successfully in 833 ms Dell Latitude E6520 19:54:14 T:140686186289024 DEBUG: UpdateItems completed successfully in 151 ms 19:54:16 T:140686186289024 DEBUG: UpdateItems completed successfully in 148 ms 19:55:17 T:140684648498944 DEBUG: UpdateItems completed successfully in 155 ms RE: EPG Grid performace - xhaggi - 2014-04-25 we will see whether we could improve the performance .. we'll definitely do some refactoring for the EPG grid. RE: EPG Grid performace - opdenkamp - 2014-04-26 2 causes: - epg grid data is refreshed each time you access the window now because of how the pvr views work. i've hooked up the "onchanged" notifications for this already, and the window should never have to refresh data unless that one is called. now it will refresh most things when you switch views - epg grid needs refactoring since it's indeed very slow the way it works now, as your log indicates RE: EPG Grid performace - xxxnelly - 2014-05-03 Thanks guys. Let me know if you want me to test or work on anything. Thanks RE: EPG Grid performace - popcornmix - 2014-05-27 I did get our profiling guy to look into the EPG slowness. Quote:Well, it looks like the thread that calls dbiplus::SqliteDataset::make_query is doing lots of SQL of the form This isn't really his area, so he can't help here, but if anyone knows about optimising SQL queries, then I believe that is where most of the time is going. RE: EPG Grid performace - negge - 2014-05-28 The query looks fine, I guess the main problem is that it's called too often. @xhaggi: is the issue opdenkamp mentioned (the fact that all views are updated everytime they are accessed) fixed in your rewrite? RE: EPG Grid performace - opdenkamp - 2014-05-28 @popcornmix the queries are executed on the background and should only be run in case the data actually changed. it should not block the ui. if it happens more often, then that's a bug. however, on systems that use an sd as storage, like the pi, i recommend disabling the option to write the data to the database in system->pvr->epg. @negge: his PR is definitely step 1 in fixing it, in case it's not fixed yet after that PR has been merged |