# SQL shared\_drafts - will it be cached

**URL:** https://meta.discourse.org/t/sql-shared-drafts/83652
**Category:** Bug
**Created:** [March 23, 2018, 1:48pm UTC](https://meta.discourse.org/t/sql-shared-drafts/83652 "2018-03-23T13:48:21Z")
**Posts on this page:** 6
**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 23, 2018, 1:48pm UTC](https://meta.discourse.org/t/sql-shared-drafts/83652/1 "2018-03-23T13:48:21Z")

</div>

> [@SQL shared\_drafts queries-will it be cached?](https://meta.discourse.org/t/sql-shared-drafts-queries-will-it-be-cached/83565):
>
> I just don’t know. The function is new, is this the usual behavior? How many topics per page, so many sql hits? 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.

I’m sorry, but I guess it’s not working properly yet.  
v2.0.0.beta4 +205

[http://toxu.blog/sql.htm](http://toxu.blog/sql.htm)

---

<div class="post-metadata">

### Author: ![codinghorror](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/codinghorror/32/110067_2.png) [@codinghorror](https://meta.discourse.org/u/codinghorror)
#### Post date: [March 24, 2018, 5:46am UTC](https://meta.discourse.org/t/sql-shared-drafts/83652/2 "2018-03-24T05:46:38Z")

</div>

@eviltrout said the N+1 is fixed. What’s the issue? You are only on +205, you should be on +230 or better.

---

<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 24, 2018, 6:12am UTC](https://meta.discourse.org/t/sql-shared-drafts/83652/3 "2018-03-24T06:12:18Z")

</div>

In fact, this problem is not solved in: v2.0.0.beta4 +230  
I gave in PM (`eviltrout`) some details.

---

<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 26, 2018, 2:49pm UTC](https://meta.discourse.org/t/sql-shared-drafts/83652/6 "2018-03-26T14:49:06Z")

</div>

I believe this should fix it - I did not want the shared drafts to be returned by the global latest as it was confusing:

[https://github.com/discourse/discourse/commit/2b161a2391a58e36e7238ce75805775da11308ea](https://github.com/discourse/discourse/commit/2b161a2391a58e36e7238ce75805775da11308ea)

---

<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 26, 2018, 3:30pm UTC](https://meta.discourse.org/t/sql-shared-drafts/83652/7 "2018-03-26T15:30:07Z")

</div>

Everything works fine. Thanks.

---

<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 26, 2018, 9:03pm UTC](https://meta.discourse.org/t/sql-shared-drafts/83652/8 "2018-03-26T21:03:03Z")

</div>

This topic was automatically closed after 5 hours. New replies are no longer allowed.