[Mondrian] Multi-threading SQL execution

Matt Campbell mkambol at gmail.com
Thu Feb 8 17:12:38 EST 2007


We've been looking into ways to improve performance when running against
large fact tables.  One candidate we identified was to multi-thread SQL
query execution.  As things stand today, in Mondrian, SQL queries are
executed sequentially.  This means that if an MDX query involves 2 fact
tables, and each fact table takes 5 seconds to query, that it takes Mondrian
at least 10 seconds to get results.  Running the two queries simultaneously
would likely produce much better speed (of course dependent on the RDBMS
capacity).

Has anyone else considered multi-threading SQL execution?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20070208/3923c25e/attachment.html 


More information about the Mondrian mailing list