Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Database Lookup Cache Lifetime

  1. #1
    Join Date
    Feb 2009
    Posts
    12

    Default Database Lookup Cache Lifetime

    What's the lifetime for the cache when you select "Enable Cache?" on a Database Value Lookup? Assume I reuse a transformation several times within a job, is the cache refreshed each time the containing transformation is called?

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    Cache is on a step basis.... it goes away when the transformation goes away... so if you use the same transformation multiples times you will have multiple caches.

    No date based expiration on the cache, when it's "full" the oldest entries will be removed (if my memory serves correct)

    Regards,
    Sven

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.