- April 27, 2007
- United Kingdom
Any thoughts as to why I am getting good performance from older versions of the TV client? - something seems to have happened to the TV Client between SVN19876 and SVN20143Yes. Our own, tweaked config file for MySQL has been introduced with RC2. The typical installation defaults of MySQL is e.g. using way too little sorting cache as it is optimized for "background" usage.
The queries itself are handtweaked to the peak - gathering program info takes around 5 ms here. The rest is ineffective GUI code.
Nevertheless MSSQL can use available RAM much more aggressive and responds to most queries directly from its cache. So while some actions (Mini-EPG, EPG import) might be faster with MySQL, M$ SQL Server will be faster for TVGuide of huge groups and everywhere where "gentle.NET" is used (e.g. channel assignment in SetupTV.exe).
P.S. On the same hardware SQL Server 2008's query response time is even 25% faster.