Database Optimization: Done!
Right.
So the database optimization is now finished. It took almost a week to optimize our 23 million episodes. But that’s not all.
With the database optimized, it’s now time to start optimizing some code and some slow queries. Some of them are already done, like the “Unseen Episodes” and the “New Episodes” pages. They should feel a bit quicker now and hopefully they wont clog all the server resources when we have a lot of users online. Fingers crossed.
We are now recalculating the total time you spent watching all your episodes. It’s way faster now, and there is a new “refresh” link next to it so that you can recount your totals whenever you feel it’s not correct.
We will continue this optimization during the next few days.
Goodie, hope the new version is coming along soon as well
heeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee
Tanks guys
Great work guys! The site indeed feels faster now, so that’s a good sign! I sure hope the new version will be up soon! Keep up the good work
!
Thanks.
It sure feels like it’s more stable and fast now. Let’s wait a couple of days more to see if it really has any effect on the performance of the website.
At least, the complaining on Twitter has stopped
Any news about the reopen of the registration? I’m really waiting for that since I discovered the site and the registry was closed. I think the site would be really helpfull for me. Anyway I’ll keep waiting
Thanks!!!
Yeah, count me as another person patiently awaiting registrations to be open again. I found another site that, for now, does something simular, but this looks to be much more feature rich, which should suit my needs just fine.
Here’s hoping for registration to be open soon!
I’m waiting for registration to open soon, but I know you’re working on the site, and I can be patient.
In the meantime, can you share the site that you are using Dan? Anything would be better than the nothing I have now.
Sure, I actually found it as a comment to another post. It’s myepisodes.com. Very simple interface, nowhere near as feature rich as this site, but like you, it will do until we can register here!
If the owner of this site wishes to delete this comment, I am OK with that.
The website loads faster which is great, but there’s one problem. Before the update i had around 24 – 25000 unseen episodes. Now I have around 16 – 17000. It’s impossible for 8000 eps to just dissappear out of nowhere…
What happened ?
@Stan that’s because we are now *only* counting the Current episodes list and not the Archived ones.
awesome work, the site loads A LOT faster. Thank You!
Thanks for the info Ivo….
Keep up the good work…
It worked fine for a while. Now it’s slow again, even when the people in the USA is sleeping. (It always worked fine on that hours)
Hi Ivo,
I don’t know what have you exacly done, but site works almost perfecly fine. Runs very fast. Great!
Keep up, and promote the site, because MyTVShow have big potential.
I am still willing to do a translation of a into Polish.
Greetings from Poland.
Estou impressionado, eu preciso dizer. Realmente muitas vezes não posso encontrar um blog que é cada educativo e divertido, e deixe-me informá-lo, você tem que bater o prego na cabeça. Seu conceito é excelente, a dificuldade é uma coisa que as pessoas não estão falando suficiente inteligente sobre. Estou muito feliz que eu tropecei ao longo deste na minha busca por algo a respeito deste.