cube-js/cube

How one can disable cache or preaggregation for large datasets?

開放

#5,341 建立於 2022年9月22日

 (2 則留言) (2 個反應) (0 位負責人)Rust (1,965 個分叉)batch import
help wanted

倉庫指標

星標
 (19,563 顆星)
PR 合併指標
 (PR 指標待抓取)

描述

Problem

Sometimes users can run smth like 'Select many dimensions and metrics for long period ". When it happens, huge portion of data is added to memory cache (we are still using redis, but I think problem will remain after adding cube store).

How can we disable adding result of query to cache by its size (e.g. limit 30 mb)? For us it's cheaper to make roundrip to db)

貢獻者指南