0003566: TV MiniGuide dosen't load prgrams when the channel set is very large (1 Viewer)

[MediaPortal-Bot]

The Tv MiniGuide loads programs (now and next) from the tv database with a query constructed in TvBusinessLayer. The query is a series of select statements in a union to form the result set. On Windows there are several limitations that may prevent the opening of a number of large table simultaneously (see <a href="http://dev.mysql.com/doc/refman/5.0/en/limits-windows.html">http://dev.mysql.com/doc/refman/5.0/en/limits-windows.html</a> [<a href="http://dev.mysql.com/doc/refman/5.0/en/limits-windows.html" target="_blank">^</a>]). In the case of the select/union statement for TvMiniGuide each select statement opens the program table; the number of select statements in my tests exceeded 750 (All Channels program group, US directv). A SQL error is presented as the result of the query execution and the result set returned to the Tv MiniGuide is empty resulting in the Tv MiniGuide being filled with "No available information" messages.

Continue reading...