# Caching - On Prem Implementation

**URL:** https://community.dremio.com/t/caching-on-prem-implementation/8959
**Category:** Uncategorized
**Created:** [March 28, 2022, 3:29am UTC](https://community.dremio.com/t/caching-on-prem-implementation/8959 "2022-03-28T03:29:04Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![vrb](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/vrb/32/4057_2.png) [@vrb](https://community.dremio.com/u/vrb)
#### Post date: [March 28, 2022, 3:29am UTC](https://community.dremio.com/t/caching-on-prem-implementation/8959/1 "2022-03-28T03:29:04Z")

</div>

Is caching (not reflections) for On Prem Installation of Dremio ? When i say caching I am referring to data that was queried previously from a remote location (S3) ? Will subsequent queries read from the local disks ?

Thanks  
VRB

---

<div class="post-metadata">

### Author: ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)
#### Post date: [April 3, 2022, 5:12pm UTC](https://community.dremio.com/t/caching-on-prem-implementation/8959/2 "2022-04-03T17:12:28Z")

</div>

@vrb That is correct, this is called cloud cache, see documentation below. It is available for both datasets (PARQUET only) and reflections

[https://docs.dremio.com/software/deployment/cloud-cache-config/](https://docs.dremio.com/software/deployment/cloud-cache-config/)

---

<div class="post-metadata">

### Author: ![vrb](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/vrb/32/4057_2.png) [@vrb](https://community.dremio.com/u/vrb)
#### Post date: [April 3, 2022, 8:23pm UTC](https://community.dremio.com/t/caching-on-prem-implementation/8959/3 "2022-04-03T20:23:20Z")

</div>

Thank you. Does the Key NUM\_CACHE\_HITS in profile indicate the cache hits ? if so what is the unit ? Number of page reads ?

---

<div class="post-metadata">

### Author: ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)
#### Post date: [April 3, 2022, 11:23pm UTC](https://community.dremio.com/t/caching-on-prem-implementation/8959/4 "2022-04-03T23:23:16Z")

</div>

@vrb Yes, indicates cache hits, will get back on the right number/unit for NUM\_CACHE\_HITS

---

<div class="post-metadata">

### Author: ![vrb](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/vrb/32/4057_2.png) [@vrb](https://community.dremio.com/u/vrb)
#### Post date: [April 3, 2022, 11:59pm UTC](https://community.dremio.com/t/caching-on-prem-implementation/8959/5 "2022-04-03T23:59:59Z")

</div>

Thank you. Also there is another field about NUM\_CACHE\_MISSES. Like to know what it indicates

---

<div class="post-metadata">

### Author: ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)
#### Post date: [April 4, 2022, 4:33pm UTC](https://community.dremio.com/t/caching-on-prem-implementation/8959/6 "2022-04-04T16:33:15Z")

</div>

@vrb Because we reading in chunks of 1MB while using async… we may read some bytes that are not needed… the difference would be small though, do you see a big difference? if so, can you please send us the profile?

NUM\_CACHE\_MISSES are reads back to the source like S3 as the block was not cached on local SSD (cloud cache)
