Since the drastic move to re-architecture StocksCafe and adding support for two new markets at the same time in April, StocksCafe website have became slower. I am aware of that and have been taking significant amount of time trying to improve it.
To be very honest, I am not 100% sure what is the true cause although I am inclined to think that it is due to a summation of reasons such as poor database configuration, increased data volume etc instead of a single cause. Speaking of which, if anyone is an expert in MySQL or MongoDB among us, please reach out :)
Anyway, over the weekend, in an attempt to speed things up, I have installed
Memcached onto StocksCafe backend. Memcached is a caching system that helps by caching data that are repeatedly used instead of hitting the database every time. It has reduce StocksCafe response time by about ......