Win Frodo 12.1 / Synology / Very slow common SQL
#3
So I have part of the logfile here.... I cant see anything out of the ordinary... If the logfile is linear in nature... My dealy appears to be after the SQL server queries, and the queries appear to be respectable 2ms 30ms even the 3000ms is liveable - considering I have thousands of tv shows....

What is strange to me - after turning debug mode on, and running this - the logfile shows an entries for;


17:24:13 T:2692 DEBUG: CMusicDatabase::GetAlbumsByWhere query: SELECT albumview.* FROM albumview WHERE albumview.strAlbum <> ''
17:24:13 T:2692 DEBUG: CMusicDatabase::GetAlbumsByWhere - query took 1 ms
17:24:13 T:2692 DEBUG: Skin Widgets: Total time needed to request recent items queries: 0:00:03.423000
17:24:13 T:2692 DEBUG: Skin Widgets: Total time needed for all queries: 0:00:09.239000
17:29:05 T:1796 DEBUG: Thread CRemoteControl 1796 terminating
17:29:56 T:440 DEBUG: ADDON: Starting service addons.
17:29:56 T:776 NOTICE: Thread CVideoInfoScanner start, auto delete: false
17:29:56 T:440 INFO: initializing python engine.
17:29:56 T:440 DEBUG: new python thread created. id=6
17:29:56 T:440 NOTICE: initialize done

What happened - between minutes 24 and 29 - thats where my 5 minutes went - but nothing in the log !!!??

A larger logfile is listed in the hope SOMEBODY PLEASE HELP (I did remove some lines - which basically listed all the tv shows - it was too long!)

<EDIT: log removed, read forum rules>
Reply


Messages In This Thread
RE: Frodo 12.1 / Synology / Very slow common SQL - by impactoz - 2013-05-02, 14:54
Logout Mark Read Team Forum Stats Members Help
Frodo 12.1 / Synology / Very slow common SQL0