# \#slow-sql

**URL:** https://meta.discourse.org/tag/slow-sql/1.md

[Latest](https://meta.discourse.org/latest.md) · [Categories](https://meta.discourse.org/categories.md) · [Tags](https://meta.discourse.org/tags.md)

---

## [Private Message Page Performance](https://meta.discourse.org/t/private-message-page-performance/39865)

<div class="topic-metadata">

**Author:** [@Falco](https://meta.discourse.org/u/Falco)\
**Replies:** 5\
**Last updated:** [September 13, 2017, 2:30pm UTC](https://meta.discourse.org/t/private-message-page-performance/39865 "2017-09-13T14:30:26Z")

</div>

Continuing the discussion from Improve performance of Topic load - ORDER BY RANDOM: The added index is great, but it excludes PMs :sadpanda:. Since we have suggested topics on the PM page (since when?) the performance …

---

## [App/models/topic\_tracking\_state - \`report\` - long response times?](https://meta.discourse.org/t/app-models-topic-tracking-state-report-long-response-times/40052)

<div class="topic-metadata">

**Author:** [@DeanMarkTaylor](https://meta.discourse.org/u/DeanMarkTaylor)\
**Replies:** 6\
**Last updated:** [February 26, 2016, 3:29am UTC](https://meta.discourse.org/t/app-models-topic-tracking-state-report-long-response-times/40052 "2016-02-26T03:29:43Z")

</div>

I’ve seen a long response times for this SQL query a few times (\> 5). The most recent occurrence is this one where it took 93.2ms: Executing action: show T+173.7 ms Reader 93.2 ms lib/freedom\_patches/active\_record\_base…

---

## [About page slow / Menu slow to disapear](https://meta.discourse.org/t/about-page-slow-menu-slow-to-disapear/24635)

<div class="topic-metadata">

**Author:** [@DeanMarkTaylor](https://meta.discourse.org/u/DeanMarkTaylor)\
**Replies:** 16\
**Last updated:** [July 21, 2015, 10:42am UTC](https://meta.discourse.org/t/about-page-slow-menu-slow-to-disapear/24635 "2015-07-21T10:42:29Z")

</div>

When selecting About from the hamburger :hamburger: menu the menu appears to be dismissed very slowly. This is kinda two bugs / issues: Menu should be dismissed immediately upon click (from a user experience / feedbac…

---

## [Improve performance of Topic load - ORDER BY RANDOM](https://meta.discourse.org/t/improve-performance-of-topic-load-order-by-random/25619)

<div class="topic-metadata">

**Author:** [@DeanMarkTaylor](https://meta.discourse.org/u/DeanMarkTaylor)\
**Replies:** 22\
**Last updated:** [March 1, 2015, 10:52pm UTC](https://meta.discourse.org/t/improve-performance-of-topic-load-order-by-random/25619 "2015-03-01T22:52:10Z")

</div>

Continuing the discussion from Slow sql queries: ##The Problem Clicking between topics is slow - for a few reasons - one of which is the generation of suggested topics. For me I currently consider this a bug because …

---

## [User Card display performance](https://meta.discourse.org/t/user-card-display-performance/23747)

<div class="topic-metadata">

**Author:** [@DeanMarkTaylor](https://meta.discourse.org/u/DeanMarkTaylor)\
**Replies:** 13\
**Last updated:** [February 24, 2015, 3:36am UTC](https://meta.discourse.org/t/user-card-display-performance/23747 "2015-02-24T03:36:25Z")

</div>

Thanks @zogstrip for this commit: https://github.com/discourse/discourse/commit/e20078a9dc34ae4b03e33277a553e41af8066942 I had mentioned performance issues with this here: For me the general loading in user cards has…