# Query lente in Discourse

**URL:** <https://meta.discourse.org/t/slow-queries-in-discourse/152494>\
**Category:** Development\
**Created:** [24 Maggio 2020, 2:47am UTC](https://meta.discourse.org/t/slow-queries-in-discourse/152494 "2020-05-24T02:47:11Z")\
**Posts on this page:** 1\
**Showing post:** 8

<div class="post-metadata">

**Author:** ![wtune](https://avatars.discourse-cdn.com/v4/letter/w/8dc957/32.png) [@wtune](https://meta.discourse.org/u/wtune)\
**Post date:** [25 Maggio 2020, 5:56am UTC](https://meta.discourse.org/t/slow-queries-in-discourse/152494/8 "2020-05-25T05:56:55Z")

</div>

Mi scuso, la query riscritta corretta dovrebbe essere

```plaintext
SELECT 
  "groups"."id", 
  "groups"."name" 
FROM 
  "groups" 
  INNER JOIN "group_users" gu ON "groups"."id" = gu."group_id" 
WHERE 
  "group_users"."user_id" = 296 
   AND (groups.id > 0) 
   AND (
    groups.visibility_level IN (0, 1, 2) 
    OR (groups.visibility_level IN (3,4) and gu.owner)
   ) 
ORDER BY 
  name ASC

```

La sottoquery con il predicato visibility\_level = 0,1,2 può essere sostituita da groups.visibility\_level IN (0, 1, 2), e la sottoquery con il predicato visibility\_level = 3,4 può essere sostituita da OR (groups.visibility\_level IN (3,4) and gu.owner).

---

_[View the full topic](https://meta.discourse.org/t/slow-queries-in-discourse/152494)._