While building a POC for a business analytics application which emphasized on faster data retrieval from business driven queries on a large volume of data, we knew we had to think out of the MySQL box. Retrieving data using MySQL, especially when the data is very huge, can take quite long.
We had to handle the 0.2 million records. The query involved searching through all of the records and took 15 odd minutes when we implemented it using MySQL :-(
