Everyone who has updated to v1.2.09104 of myTV should run download, configure and run this executable.
It's part of a performance test I'm conducting (more details to come), but if you are running 09104 and have a few minutes spare, please help out by running this.
You also need a TheTVDB Useraccount Identifier for this to work - you get one of those by logging in (or registering, if you haven't already done so) at TheTVDB.com and clicking the link for your "account". Once there you will find your identifier in the textbox labelled "Account Identifier".
Once you have your identifier to hand, open the webCollectionUtil.exe.config file and find the <applicationSettings> section. First make sure the SQLServer and DBName settings are correct (and if not, edit them so they are), then find the section that looks like
<setting name="TheTVDBID" serializeAs="String">
<value></value>
</setting>
and insert your TheTVDB Account Identifier between the <value> and </value> tags.
When you have done this, run the application from a command prompt like this;
webCollectionUtil.exe -putCollection
and go make yourself a cup of coffee or something. If you have a large collection, this will take some time initially.
Right, so I mentioned performance test. Basically I'm just seeing what kind of performance hit we'll be taking on the DB server once we have a table with a few million rows that needs to be queried on each and every load of the [new] Web Collection page. Hopefully it won't be too bad, and the new collection page will go live with the new website.