# SQL shared\_drafts queries-will it be cached?

**URL:** https://meta.discourse.org/t/sql-shared-drafts-queries-will-it-be-cached/83565
**Category:** Bug
**Created:** [March 22, 2018, 3:28pm UTC](https://meta.discourse.org/t/sql-shared-drafts-queries-will-it-be-cached/83565 "2018-03-22T15:28:08Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Stranik](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/stranik/32/85638_2.png) [@Stranik](https://meta.discourse.org/u/Stranik)
#### Post date: [March 22, 2018, 3:28pm UTC](https://meta.discourse.org/t/sql-shared-drafts-queries-will-it-be-cached/83565/1 "2018-03-22T15:28:08Z")

</div>

I just don’t know. The function is new, is this the usual behavior?  
How many topics per page, so many sql hits?

 ![gr](https://global.discourse-cdn.com/meta/original/3X/5/e/5ecdb9f3561cdea5a4757f1e5e66c4411a7cb381.gif)

_v2.0.0.beta4 +192_

* * *

_23.03 - v2.0.0.beta4 +214_  
**Add:** I’m sorry, but I guess it’s not working properly yet.

---

<div class="post-metadata">

### Author: ![Falco](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/falco/32/179432_2.png) [@Falco](https://meta.discourse.org/u/Falco)
#### Post date: [March 22, 2018, 4:46pm UTC](https://meta.discourse.org/t/sql-shared-drafts-queries-will-it-be-cached/83565/2 "2018-03-22T16:46:14Z")

</div>

Looks like a N+1 when viewing `/latest` of the shared drafts category @eviltrout

---

<div class="post-metadata">

### Author: ![eviltrout](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/eviltrout/32/5275_2.png) [@eviltrout](https://meta.discourse.org/u/eviltrout)
#### Post date: [March 22, 2018, 8:28pm UTC](https://meta.discourse.org/t/sql-shared-drafts-queries-will-it-be-cached/83565/3 "2018-03-22T20:28:18Z")

</div>

Thanks, I’ve fixed it here:

[https://github.com/discourse/discourse/commit/41fc8e32e272324001905ee0d9b7d2c18357ebc5](https://github.com/discourse/discourse/commit/41fc8e32e272324001905ee0d9b7d2c18357ebc5)

---

<div class="post-metadata">

### Author: ![eviltrout](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/eviltrout/32/5275_2.png) [@eviltrout](https://meta.discourse.org/u/eviltrout)
#### Post date: [March 22, 2018, 8:28pm UTC](https://meta.discourse.org/t/sql-shared-drafts-queries-will-it-be-cached/83565/4 "2018-03-22T20:28:21Z")

</div>


