Reply to thread

Message

<blockquote data-quote="morpheus_xx" data-source="post: 1028243" data-attributes="member: 48495">I think we won't gain too much with more tweaking of the DB model (indices).I would like to see the impact of querying thumbnails with the MediaItems. If the DB needs to join and sort tables that contain (large) binary data, this is both CPU, IO and memory intensive.It should be possible to remove the ThumbnailSmallAspect/ThumbnailLargeAspect from the list of optional aspects to be queried. Please check the selected Skin's plugin.xml and comment the registration of thumb aspects. I'm not sure if they are also included by code (I think not), then this should be commented also.See this for example: <a href="https://github.com/MediaPortal/MediaPortal-2/blob/dev/MediaPortal/Incubator/Titanium/plugin.xml#L16-L45" target="_blank">https://github.com/MediaPortal/MediaPortal-2/blob/dev/MediaPortal/Incubator/Titanium/plugin.xml#L16-L45</a>As I now already load &quot;album thumbs&quot; (*1) from MediaLibrary, we could do the same for all thumbs. This will reduce the server processing and network transfer times for MediaItems, but brings (much?) overhead for requesting each thumb per HTTP.(*1) an &quot;Album&quot; thumb is in fact the first available thumbnail of all AudioItems that have the album title.</blockquote>

[QUOTE="morpheus_xx, post: 1028243, member: 48495"] I think we won't gain too much with more tweaking of the DB model (indices). I would like to see the impact of querying thumbnails with the MediaItems. If the DB needs to join and sort tables that contain (large) binary data, this is both CPU, IO and memory intensive. It should be possible to remove the ThumbnailSmallAspect/ThumbnailLargeAspect from the list of optional aspects to be queried. Please check the selected Skin's plugin.xml and comment the registration of thumb aspects. I'm not sure if they are also included by code (I think not), then this should be commented also. See this for example: [url]https://github.com/MediaPortal/MediaPortal-2/blob/dev/MediaPortal/Incubator/Titanium/plugin.xml#L16-L45[/url] As I now already load "album thumbs" (*1) from MediaLibrary, we could do the same for all thumbs. This will reduce the server processing and network transfer times for MediaItems, but brings (much?) overhead for requesting each thumb per HTTP. (*1) an "Album" thumb is in fact the first available thumbnail of all AudioItems that have the album title. [/QUOTE]

Verification