Reply to thread

Message

<blockquote data-quote="ltfearme" data-source="post: 1130751" data-attributes="member: 52219">Over 200 hundred. Yes you should test with more, it will show that the execution path taken it is not optimised when you do the option toggle vs the import execution path.Import:[CODE]var episodesForCount = DBSeries.GetEpisodesForCount();foreach (DBSeries series in allSeries){&nbsp;&nbsp; DBSeries.UpdateEpisodeCounts(series, episodesForCount);}[/CODE]The Option Toggle you Added:[CODE]foreach (var series in allSeries){&nbsp;&nbsp; int epsTotal = 0;&nbsp;&nbsp; int epsUnWatched = 0;&nbsp;&nbsp; DBEpisode.GetSeriesEpisodeCounts(series[DBSeries.cID], out epsTotal, out epsUnWatched);&nbsp;&nbsp; series[DBOnlineSeries.cEpisodeCount] = epsTotal;&nbsp;&nbsp; series[DBOnlineSeries.cEpisodesUnWatched] = epsUnWatched;&nbsp;&nbsp; series.Commit();}[/CODE]As you can see its two different paths. The reason why its faster is because DBSeries.GetEpisodesForCount(); does the database query needed for all series, where as you're doing a query on every single series.</blockquote>

[QUOTE="ltfearme, post: 1130751, member: 52219"] Over 200 hundred. Yes you should test with more, it will show that the execution path taken it is not optimised when you do the option toggle vs the import execution path. Import: [CODE] var episodesForCount = DBSeries.GetEpisodesForCount(); foreach (DBSeries series in allSeries) { DBSeries.UpdateEpisodeCounts(series, episodesForCount); } [/CODE] The Option Toggle you Added: [CODE] foreach (var series in allSeries) { int epsTotal = 0; int epsUnWatched = 0; DBEpisode.GetSeriesEpisodeCounts(series[DBSeries.cID], out epsTotal, out epsUnWatched); series[DBOnlineSeries.cEpisodeCount] = epsTotal; series[DBOnlineSeries.cEpisodesUnWatched] = epsUnWatched; series.Commit(); } [/CODE] As you can see its two different paths. The reason why its faster is because DBSeries.GetEpisodesForCount(); does the database query needed for all series, where as you're doing a query on every single series. [/QUOTE]

Verification