Wednesday, August 12, 2009

Performance Issues Resolved

Recently i notice that page loading were getting slower and slower (up to 5 seconds for a page to load during peak hours). When checking the server logs I did not notice any high CPU usage. When coming back from lunch today, I realize that I have done zero optimization to my database. Database optimization is not a big deal when your are only dealing with a couple hundred rows of data, but when you get into the thousands you start to see a degrade in performance.

I have done some simple optimization to the myVidster's mySQL tables. Simple stuff like adding indexs and running the OPTIMIZE command on the tables. I also setup a nightly cron job to optimize my index files for video searching (Zend Lucene).

The final result was page load times and search gain a 2x to 3x boost! Hopefully the performance issues did not cause me to lose any users.

Thursday, August 6, 2009

~40,000 visits a month, not too shabby

It has been a while sense I posted an update on this blog. This does not mean that myVidster is not growing. In fact myVidster's growth has been very positive in the last 6 months.

As of today here are some key stats of myVidster.

# of Users: 3,925
# of Collections: 3,923
# of Videos Collected: 16,724
Visits Per Month: ~40,000

I will admit that these stats are not stellar in comparison to successful startups like twitter, but for a self funded project I am very proud of site's growth.