GNOME Bugzilla – Bug 652191
Browsing of "Artists" folder leads to "timeout" in Marantz M-CR603
Last modified: 2011-09-13 06:01:48 UTC
When retrieving albums, genres, or years, I can see with the debug mode on that Rygel and the Media Export plugin are quite fast at returning results. However, when I try to retrieve artists, each artist retrieval is as slow as 1s. In practice, when retrieving 50 artists at a time, this takes way too long and my DLNA device (Marantz M-CR603) sort of times out and does not display any artists.
Can you please attach a wireshark dump of the communication between rygel and the device as well as a log output of rygel run with with -g 5?
Created attachment 189746 [details] Artist lookup "timeout" (Rygel debug log)
Created attachment 189747 [details] Artist lookup "timeout" (Wireshark dump)
Created attachment 189748 [details] Genre lookup (Rygel debug log)
Created attachment 189750 [details] Genre lookup (Wireshark dump)
I attached Rygel debug logs and Wireshark dumps of what happens when I lookup artists (failure) or genres (success).
Does the following improve the situation: echo "CREATE INDEX idx_artist_album ON meta_data(author,album); CREATE INDEX idx_album_artist ON meta_data(album,author); ANALYZE;" | sqlite3 $HOME/.cache/rygel/media-export.db improve the situation?
I don't know if you figured it out on your own, Jens, but the issue is specific of the MediaExport plugin. With the Tracker plugin, no such issue is present. As for your command for the MediaExport database, it improves things a lot: querying artists is now very fast and does not time out. Thanks!
And the SQLite command itself was fast too, which was a surprise as I thought that it would take some time.
This has been fixed with http://git.gnome.org/browse/rygel/commit/?id=9bdebf59bbc0010dd347e07948cbfc375e6908b6 commit 9bdebf59bbc0010dd347e07948cbfc375e6908b6 Author: Jens Georg <mail@jensge.org> Date: Thu Sep 8 21:17:47 2011 +0200 media-export: Add indices for virtual containers which will be included in the next stable release 0.12.1. Users of the previous stable release are advised to run the queries themselves.