Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: CDA cache mechanisam & functionality architectural level question..

  1. #1
    Join Date
    Feb 2013
    Posts
    530

    Default CDA cache mechanisam & functionality architectural level question..

    Hi.. How CDA works ?

    I have a SQL query, I executed it with 4 records.. and I cached it in CDA for next 1 hour... Later the database is updated(Let's say with 2 more new records) with some new records and the query executed after one hour...

    Now will the CDA execute the Query for all the 6 records ? Or Will it only append with newly coming 2 records ?

    Dear experts, can some one share your knowledge regarding in this ?

    Snapshot is more worth to understand

    Name:  issue3.jpg
Views: 22
Size:  25.8 KB


    Thanks,
    Sadakar
    BI developer

  2. #2
    Join Date
    Jul 2007
    Posts
    2,497

    Default

    CDA doesn't do any row level analysis of the resultset. If the cache time expired, the previous one is discarded and the entire resultset is cached - simple as that
    Pedro Alves
    Meet us on ##pentaho, a FreeNode irc channel

  3. #3
    Join Date
    Feb 2013
    Posts
    530

    Default

    Hi Pedro, thank you for the response....

    If the entire result set is discarded and then cached with new result set ,where can I find the changes made on it (i.e., Will the changes appears in any file/some location dynamically ) ...

    How to know it practically with a confirmation ?


    Sadakar
    BI developer
    Last edited by sadakar; 09-03-2013 at 05:46 AM.

  4. #4
    Join Date
    Jul 2007
    Posts
    2,497

    Default

    If you mean the physical files on disk, you shouldn't worry about that. It either uses ehcache or hazelcast (with CDC)
    Pedro Alves
    Meet us on ##pentaho, a FreeNode irc channel

  5. #5
    Join Date
    Feb 2013
    Posts
    530

    Default

    Thank you Pedro, I need to have a look at CDC now.

    Finally I got to understand when ever new data comes the cache is replaced with entire result set but not , only with the newly coming data

    Sadakar

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.