Re: [Banshee-List] Warning: "DELETE FROM CoreCache"

[Hans Oesterholt <hans oesterholt net>]

I think it tells you that the query is taking more time than expected.

2013/2/19 Klaus Zeitler <info klauszeitler de>

Hello,
when I run banshee with --debug I see lots of warnings similar to:

--- snip ---

[4 Warn  23:09:57.328] Executed in 806ms
                    DELETE FROM CoreCache WHERE ModelID = 53;
                        INSERT INTO CoreCache (ModelID, ItemID) SELECT 53, CoreTracks.TrackID FROM CoreTracks CROSS JOIN CoreArtists,CoreAlbums, CoreSmartPlaylistEntries WHERE CoreArtists.ArtistID = CoreTracks.ArtistID AND CoreAlbums.AlbumID = CoreTracks.AlbumID  AND  CoreSmartPlaylistEntries.TrackID = CoreTracks.TrackID AND CoreSmartPlaylistEntries.SmartPlaylistID = 6  ORDER BY
                    CoreArtists.NameSortKey ASC,
                    CoreAlbums.TitleSortKey ASC,
                    CoreTracks.Disc ASC,
                    CoreTracks.TrackNumber ASC

--- snip ---

What does this mean?

Thanks

Klaus

--
 -------------------------------
|  Klaus Zeitler                |
|  Email: info klauszeitler de  |
 -------------------------------
---
The only way to get rid of a temptation is to yield to it. -- Oscar Wilde
_______________________________________________
banshee-list mailing list
banshee-list gnome org
https://mail.gnome.org/mailman/listinfo/banshee-list  (unsubscribe here)