MyTVShows Blog

Hello there!

As you may have noticed in the last couple of weeks, MyTVShows has been even slower then it used to be. While we don’t come up with the new version (that’s being rewritten from scratch), we are going to make some changes to the current version.

First of all, we are making some changes to our database in order to improve the performance. We have a lot of data (more than 23 million episodes) that we need to optimize. And, to do it on such a large number of episodes, we are doing it slowly. It may take some days (maybe a whole week) before everything is ready. We are currently at 30% in this process.

Then, we will have to change some code, to make the database queries faster. Hopefully this will be a quick fix once all the database optimizations are done.

We will also be changing some things on the website to improve the performance. For instance, the “unseen episodes” page currently lists all of your unseen episodes. If you had like 10.000 unseen episodes, we would list all those episodes, making the site to become very slow for you and everyone else. We are now limiting this list to only 500 episodes (200 on the mobile version). So, if you have more than 500 unseen episodes, please go to the corresponding show/season page to manage them.

The public profile page of each user now shows only his/her current shows instead of showing also the archived ones.

While we are optimizing the database tables, we are also cleaning the duplicated episodes and “invisible” episodes (the ones that you can’t see on your library but you keep getting the message saying you still have unaired episodes for that show/season). We are being very careful not to delete anything that we shouldn’t. If you think we deleted any of your episodes, please get in touch with us, to see if we cant get them back from the backups (yes, we have backups).

By the end of this process, hopefully, we will have a much faster experience on MyTVShows. Depending on how it goes, we may or may not reopen the registrations to new users.

Fingers crossed!

This entry was posted on Friday, November 19th, 2010 at 15:21 and is filed under Annoucements. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.