Data Retrieval Optimisation using Infobright

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 :-(
 
In order to overcome this bottleneck, we concluded on using a tool that can provide a columnar database experience.
 
We went forward with Infobright. The same lot of data was now retrieved in 3-4 seconds :-) The same query on 1.3 million records took us 8-10 secs.
 
However, there are some limitations in Infobright:
1. Not all queries can be satisfied with the Infobright optimizer.
2. Infobright can handle up to 32 concurrent queries at this time.
3. DML (insert, update, delete; only available in the Enterprise edition) only supports table-level locking, which could reduce concurrency if much DML occurs in an Infobright warehouse.
4. No ALTER TABLE support.
 
Source and for more information : http://www.infobright.org and http://www.infobright.com