from personal experience, you don't gain expertise in scalability until it's too late and the website is down and you are running around to get it back up!!!
when i first initially coded the website, i took some shortcuts to get the product out there soon before it was too late. Once we launched and the traffic started growing and i noticed the slow response times, i went back to the basics and went through all my pages and tried to optimize as much as i could. A lot of it I had to learn on the fly. Anything from SQL query optimization, playing around with database indexes to speed up the searches and then implementing Memcache and finally separating and loadbalancing the database and web server. Many of these issues you can prepare yourself for but the best way is to fall right in the middle of it when your site goes down and you need to get it back up!!
i'm sure everyone who was in the same position at one point would agree that even though the site is down and you have to go through and optimize a lot of code, it's GREAT FEELING knowing that people are actually visiting your site and using your creation!
Comments
from personal experience, you don't gain expertise in scalability until it's too late and the website is down and you are running around to get it back up!!!
when i first initially coded the website, i took some shortcuts to get the product out there soon before it was too late. Once we launched and the traffic started growing and i noticed the slow response times, i went back to the basics and went through all my pages and tried to optimize as much as i could. A lot of it I had to learn on the fly. Anything from SQL query optimization, playing around with database indexes to speed up the searches and then implementing Memcache and finally separating and loadbalancing the database and web server. Many of these issues you can prepare yourself for but the best way is to fall right in the middle of it when your site goes down and you need to get it back up!!
i'm sure everyone who was in the same position at one point would agree that even though the site is down and you have to go through and optimize a lot of code, it's GREAT FEELING knowing that people are actually visiting your site and using your creation!