Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Mondrian and Luciddb index

  1. #1
    Join Date
    Mar 2009
    Posts
    205

    Default Mondrian and Luciddb index

    Hi all,

    I'm starting to use Luciddb as a BI database with Mondrian and I have some questions. I am experimenting very average performance. I was expecting 10 times faster than SQLServer but it is almost the same. I'm mesuring time with some MDX queries with mondrian against a star schema with SQLServer and Luciddb.

    1. What indexes should be created with LucidDB (only fact tables, on surrogate key ?)
    2. I'm using Luciddb on Windows: Is it really faster on Linux ?
    3. our fact tables only have 300K - 500K records. Is the speed difference only noticeable with higher volume ?

    Any experience with LucidDB & Mondrian would be appreciated.

    Thanks !


    Hugues

  2. #2
    Join Date
    Mar 2009
    Posts
    205

    Default

    I got no answers so far. I.m going to turn it into a simpler question. Right now, with all the testing, I see no gain using LucidDB.

    Is anobody out there using Lucid with Mondrian ?
    Have you gained any performance from a former standard database ?

    Thanks !

    Hugues

  3. #3
    Join Date
    Sep 2009
    Posts
    810

    Default

    It's worth asking this on: http://www.luciddb.org/forums/

    Cheers
    Slawo

  4. #4

    Default

    1. all join keys, as well as the time dimension
    2. it shouldn't matter. java is java.
    3. what response times are you getting? you should be in the 100-200ms range with that small amount of data. If not, your indexes aren't right.

    Also, be sure you ANALYZE TABLE [table] ESTIMATE STATISTICS FOR ALL COLUMNS; after defining the indexes

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.