… was sponsored by Infobright, but this analysis reflects my independent testing from an objective viewpoint. I performed two different types of… typical OLAP analysis queries. These tests were intended to approximate what would happen if you ported a MyISAM OLAP application to ICE. My testing suggests that with some basic testing, an application could be ported…
Post: New OLAP Wikistat benchmark: Introduction and call for feedbacks
January 28, 2010 By 16 Comments
…. I have next goals with proposed benchmark: Compare engines in OLAP queries for planning, predicting growth, analyzing access patterns to wiki… results ( so stay with MySQLPerformanceBlog 
) I’d like also to test also Paraccel, Vertica and KickFire systems, but I do not…
Post: Shard-Query adds parallelism to queries
November 15, 2010 By 16 Comments
… SQL via ShardQuery and it prints the results. Test #1 This set of queries tests the most basic aggregation (count(*)) on a… that Shard-Query performs better is that it turns the OLAP query into something more like OLTP. Instead of getting one… only until we run out of memory bandwidth. Test #2 My second test involved the next four queries on Vadim’s list…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 22 Comments
…) made a good candidate for testing, as it had been tested before:Another MPB postLucid DB testing The raw data is a completely… it is important to test complex queries involving joins and aggregation. A star schema is the most common OLAP/DW data model… testing was limited to a subset of Vadim’s test queries (see that post). As this new test schema is normalized, Vadim’s test…
