Reply to thread

Message: <blockquote data-quote="Guzzi" data-source="post: 570073" data-attributes="member: 55213">AW: Slow to load initially the genres viewHi Damien,I have seen, that you have moved the issue 23 to target 2.6.Issue 21:       Not all episodes are displayed in the configuration window when there is a large number of episodes in database ...Did you ever try to give longer timeouts for SQL-query or using more buffer memory? I think default timeout is 30 s. and cannot be changed "from outside" - so would require change in code, right? I tried the statement in SQL-commandline and it took approx 166 seconds, but completed successfully, so there might be some  things to try on your side:- Increase timeout - maybe just for this query ("if (bigJob) cmd.CommandTimeout = 200;")- Try use memory for temporary structures instead if filespace (PRAGMA temp_store = 2)- Try "in-memory" DB to start DB fully in RAM (should be no problem for most HTPCs I supppose?)- Is it possible to inclease the transaction buffers? Because it's a huge query, this might help?I am no programmer, just did some reading, e.g. h**p://web.utk.edu/~jplyon/sqlite/SQLite_optimization_FAQ.htmlMaybe that helps to find a fix?Thanks for all your work, GuzziPS: THere might also be the possibility of an ugly hack:If you process a simpler select query (something like select count ...) in advance, this might properly prepare this big query (prepared select). This also can be seen in the GUI, when at first time entering there is only 1 episode, going back and returning shows them all as expected. Not nice, but at least a workaround?[CODE]select online_episodes.CompositeID, online_episodes.EpisodeID, online_episodes.SeriesID, online_episodes.EpisodeIndex as online_episodesEpisodeIndex , online_episodes.SeasonIndex, online_episodes.EpisodeName, online_episodes.Watched, online_episodes.Summary, online_episodes.FirstAired, online_episodes.OnlineDataImported, online_episodes.GuestStars, online_episodes.Director, online_episodes.Writer, online_episodes.Hidden, online_episodes.lastupdated, online_episodes.DownloadPending, online_episodes.DownloadExpectedName, online_episodes.ThumbUrl, online_episodes.thumbFilename, online_episodes.Combined_episodenumber, online_episodes.Combined_season, online_episodes.DVD_chapter, online_episodes.DVD_discid, online_episodes.DVD_episodenumber, online_episodes.DVD_season, online_episodes.IMDB_ID, online_episodes.Language, online_episodes.ProductionCode, online_episodes.Rating, online_episodes.absolute_number, online_episodes.airsafter_season, online_episodes.airsbefore_episode, online_episodes.airsbefore_season, online_episodes.seasonid, online_episodes.EpImgFlag, local_episodes.EpisodeFilename, local_episodes.CompositeID, local_episodes.SeriesID, local_episodes.SeasonIndex, local_episodes.EpisodeIndex, local_episodes.LocalEpisodeName, local_episodes.LocalImportProcessed, local_episodes.AvailableSubtitles, local_episodes.CompositeID2, local_episodes.EpisodeIndex2, local_episodes.videoWidth, local_episodes.videoHeight, local_episodes.localPlaytime, local_episodes.VideoCodec, local_episodes.VideoBitrate, local_episodes.VideoFrameRate, local_episodes.VideoAspectRatio, local_episodes.AudioCodec, local_episodes.AudioBitrate, local_episodes.AudioChannels, local_episodes.ext, local_episodes.Removable, local_episodes.StopTime, local_episodes.FileDateAdded, local_episodes.FileDateCreated, local_episodes.AudioTracks, local_episodes.TextCount from online_episodes left join local_episodes on (local_episodes.CompositeID=online_episodes.CompositeID)  where online_episodes.CompositeID not in (select distinct local_episodes.CompositeID2 from local_episodes where local_episodes.CompositeID2 != '') union select online_episodes.CompositeID, online_episodes.EpisodeID, online_episodes.SeriesID, online_episodes.EpisodeIndex as online_episodesEpisodeIndex , online_episodes.SeasonIndex, online_episodes.EpisodeName, online_episodes.Watched, online_episodes.Summary, online_episodes.FirstAired, online_episodes.OnlineDataImported, online_episodes.GuestStars, online_episodes.Director, online_episodes.Writer, online_episodes.Hidden, online_episodes.lastupdated, online_episodes.DownloadPending, online_episodes.DownloadExpectedName, online_episodes.ThumbUrl, online_episodes.thumbFilename, online_episodes.Combined_episodenumber, online_episodes.Combined_season, online_episodes.DVD_chapter, online_episodes.DVD_discid, online_episodes.DVD_episodenumber, online_episodes.DVD_season, online_episodes.IMDB_ID, online_episodes.Language, online_episodes.ProductionCode, online_episodes.Rating, online_episodes.absolute_number, online_episodes.airsafter_season, online_episodes.airsbefore_episode, online_episodes.airsbefore_season, online_episodes.seasonid, online_episodes.EpImgFlag, local_episodes.EpisodeFilename, local_episodes.CompositeID, local_episodes.SeriesID, local_episodes.SeasonIndex, local_episodes.EpisodeIndex, local_episodes.LocalEpisodeName, local_episodes.LocalImportProcessed, local_episodes.AvailableSubtitles, local_episodes.CompositeID2, local_episodes.EpisodeIndex2, local_episodes.videoWidth, local_episodes.videoHeight, local_episodes.localPlaytime, local_episodes.VideoCodec, local_episodes.VideoBitrate, local_episodes.VideoFrameRate, local_episodes.VideoAspectRatio, local_episodes.AudioCodec, local_episodes.AudioBitrate, local_episodes.AudioChannels, local_episodes.ext, local_episodes.Removable, local_episodes.StopTime, local_episodes.FileDateAdded, local_episodes.FileDateCreated, local_episodes.AudioTracks, local_episodes.TextCount from online_episodes left join local_episodes on (local_episodes.CompositeID2=online_episodes.CompositeID)  where local_episodes.CompositeID2 != '' order by online_episodesEpisodeIndex asc[/CODE]</blockquote>

Verification