Reply to thread

Message: <blockquote data-quote="MJGraf" data-source="post: 1028498" data-attributes="member: 17886">ok, seems like I'm behind the current development - my build was based on an old EXP_WIP branch, which currently does no longer exist (probably one of your first Alpha3-test-branches...). Will rebase to current dev and report how this feels like...I just tested with Titanium skin - very interesting, didn't follow all the developments there. What I can see from my custom logs is that you query for every album the ThumbnailLargeAspect of the first track using LIMIT=1 in the query. To give you an impression how this looks like on the database side, here is a short excerpt of the log:[SPOILER][2013-09-21 19:26:23,776] [4422590] [39  ] [DEBUG] - MediaLibrary: Search time 00:00:00.0099016 for query MediaItemQuery: NecessaryRequestedMIATypes: [493f2b3b-8025-4db1-80dc-c3cd39683c9f, 1fda5774-9ac5-4873-926c-e84e3c36a966], OptionalRequestedMIATypes: [], Filter: [AudioItem.Album EQ '03 Bonnie & Clyde (feat. Beyonce Knowles)], SortInformation: [MediaPortal.Common.MediaManagement.MLQueries.SortInformation] LIMIT 1[2013-09-21 19:26:23,838] [4422652] [39  ] [DEBUG] - MediaLibrary: Search time 00:00:00.0220414 for query MediaItemQuery: NecessaryRequestedMIATypes: [493f2b3b-8025-4db1-80dc-c3cd39683c9f, 1fda5774-9ac5-4873-926c-e84e3c36a966], OptionalRequestedMIATypes: [], Filter: [AudioItem.Album EQ 'Live' Bullet], SortInformation: [MediaPortal.Common.MediaManagement.MLQueries.SortInformation] LIMIT 1[2013-09-21 19:26:23,931] [4422745] [39  ] [DEBUG] - MediaLibrary: Search time 00:00:00.0238603 for query MediaItemQuery: NecessaryRequestedMIATypes: [493f2b3b-8025-4db1-80dc-c3cd39683c9f, 1fda5774-9ac5-4873-926c-e84e3c36a966], OptionalRequestedMIATypes: [], Filter: [AudioItem.Album EQ (The Best of) New Order], SortInformation: [MediaPortal.Common.MediaManagement.MLQueries.SortInformation] LIMIT 1[2013-09-21 19:26:23,968] [4422782] [28  ] [DEBUG] - MediaLibrary: Search time 00:00:00.2021178 for query MediaItemQuery: NecessaryRequestedMIATypes: [493f2b3b-8025-4db1-80dc-c3cd39683c9f, 1fda5774-9ac5-4873-926c-e84e3c36a966], OptionalRequestedMIATypes: [], Filter: [AudioItem.Album EQ #1 Hits 1980-1984], SortInformation: [MediaPortal.Common.MediaManagement.MLQueries.SortInformation] LIMIT 1[2013-09-21 19:26:24,016] [4422830] [28  ] [DEBUG] - MediaLibrary: Search time 00:00:00.0177425 for query MediaItemQuery: NecessaryRequestedMIATypes: [493f2b3b-8025-4db1-80dc-c3cd39683c9f, 1fda5774-9ac5-4873-926c-e84e3c36a966], OptionalRequestedMIATypes: [], Filter: [AudioItem.Album EQ (pronounced 'leh-'nérd 'skin-'nérd)], SortInformation: [MediaPortal.Common.MediaManagement.MLQueries.SortInformation] LIMIT 1[2013-09-21 19:26:24,051] [4422865] [27  ] [DEBUG] - MediaLibrary: Search time 00:00:00.0110100 for query MediaItemQuery: NecessaryRequestedMIATypes: [493f2b3b-8025-4db1-80dc-c3cd39683c9f, 1fda5774-9ac5-4873-926c-e84e3c36a966], OptionalRequestedMIATypes: [], Filter: [AudioItem.Album EQ '74 Jailbreak], SortInformation: [MediaPortal.Common.MediaManagement.MLQueries.SortInformation] LIMIT 1[2013-09-21 19:26:24,093] [4422907] [28  ] [DEBUG] - MediaLibrary: Search time 00:00:00.0123668 for query MediaItemQuery: NecessaryRequestedMIATypes: [493f2b3b-8025-4db1-80dc-c3cd39683c9f, 1fda5774-9ac5-4873-926c-e84e3c36a966], OptionalRequestedMIATypes: [], Filter: [AudioItem.Album EQ 'Round About Midnight], SortInformation: [MediaPortal.Common.MediaManagement.MLQueries.SortInformation] LIMIT 1[2013-09-21 19:26:24,112] [4422926] [39  ] [DEBUG] - MediaLibrary: Search time 00:00:00.0128828 for query MediaItemQuery: NecessaryRequestedMIATypes: [493f2b3b-8025-4db1-80dc-c3cd39683c9f, 1fda5774-9ac5-4873-926c-e84e3c36a966], OptionalRequestedMIATypes: [], Filter: [AudioItem.Album EQ 100% Rock, Volume 2], SortInformation: [MediaPortal.Common.MediaManagement.MLQueries.SortInformation] LIMIT 1[/SPOILER]That means these queries (including reading into RAM) take between 1ms and 200ms - mostly depending on the size of the embedded coverart. When I understand the code correctly which implements the LIMIT=1 parameter, then we are querying all the tracks, but we are reading only the first one into RAM using the IDataReader.I have no clue how this works on client side (will have a look into the code tonight). But my feeling is that it may be even faster if we first query without the ThumbnailLargeAspect (LIMIT=1) and then just use the MediaItemID to fetch the ThumbnailLargeAspect of this particular MediaItem. I think I can test this with my synthetic Read Test 1 as I already planned (just taking out the ThumbnailLargeAspect of the OptionalMIAs) and comparing the pure query time (without the read time into RAM) with the one when ThumbnailLargeAspect is included. Don't know if I will have the time this weekend, but I will test it...</blockquote>

Verification