Case Study: Improving Performance of MySQL, Thinking Sphinx in a Rails app

Recently, we faced a huge performance problem with one of our installed apps. The application is a Call Center ERP solution. The Call model is updated very frequently as there are about approximately 8,000 - 10,000 calls being made everyday. For every action there is an audit trail, so updates and inserts into database are … Continue reading Case Study: Improving Performance of MySQL, Thinking Sphinx in a Rails app

IndexTank – So long and thanks for all the fish!

IndexTank got acquired by LinkedIn just a while back and I received a newsletter saying that they may discontinue services in 6 months. My tweet about this got a few responses from Pat Allen (@pat - the creator of Flying Sphinx) and others, which ended up with me promising a brief comparison between Thinking Sphinx … Continue reading IndexTank – So long and thanks for all the fish!

How to submit sitemap to search engines

There are many ways that can be used to submit sitemap to search engines.Lets discuss approaches1. Put sitemap.xml in public folder and you are done.    Crawlers will find it through url    http://yourdomain.com/sitemap.xml2. There are many online sites which generates sitemaps for you.    like http://www.xml-sitemaps.com/3. Open following urls in browser. Be sure to add xml sitemap path … Continue reading How to submit sitemap to search engines