… it is extremely easy to construct queries against. It is also very easy to define an OLAP cube over a star schema…_time change the performance? Each “flight” of queries represents a set of drill-down queries to find an anomaly. I am going… a query with only one join, I’ve tested performance of the query with the join in both directions. Explain for query Q1…
Comment: Shard-Query adds parallelism to queries
February 24, 2011 By 18 Comments
… cluster-db / shard-query with mondrian for doing olap cubes? Also, how hard would it be to modify shard-query to work with… sqlite3 dbs running on a variety of platforms and doing queries against sqlite3 using cluster-db.. The load/performance for doing… be ok if i partition the tables often enough, since queries would be read-only, and the benefit would be to…
Comment: Distributed Set Processing with Shard-Query
May 14, 2011 By 27 Comments
… course, there is a large class of OLAP applications which can be reimplemented using Shard-Query framework. This is a potentially great… companies can live with these limitations. Just one comment: Shard-Query is quite difficult to integrate into regular enterprise application where…
Comment: Top 5 Wishes for MySQL
January 14, 2008 By 10 Comments
…. I came from Oracle and SQL Server background, where parallel query and partition give you the performance for multiple CPUs and… not there in terms of parallel queries, which are so fundimental to ETL process and OLAP processing. Hope MySQL catch up with…
Comment: New OLAP Wikistat benchmark: Introduction and call for feedbacks
January 29, 2010 By 16 Comments
… OLAP benchmarks. Either I do not think OLTP oriented FireBird and PostgresSQL will be good for proposed benchmark. I expect that queries…
Comment: Air traffic queries in MyISAM and Tokutek (TokuDB)
November 6, 2009 By 26 Comments
… you see it is doing better than MyISAM in all queries.” But MyISAM isn’t known for being good at OLTP… “even though TokuDB is better at this benchmark of an OLAP workload, it does OLTP well too”…?
