lemmy/crates/db_schema/src
dullbananas c4fc3a8ede
Optimize stuff in attempt to fix high amount of locks, and fix comment_aggregates.child_count (#4696)
* separate triggers

* auto_explain.log_triggers=on

* Revert "auto_explain.log_triggers=on"

This reverts commit 078b2dbb9b.

* Revert "separate triggers"

This reverts commit 95600da4af.

* bring back migration

* re-order statements

* add comment about statement ordering

* no redundant updates

* optimize post_aggregates update in comment trigger

* set comment path in trigger

* update comment_aggregates.child_count using trigger

* move `LEFT JOIN post` to inner query

* clean up newest_comment_time_necro

* add down.sql
2024-05-09 08:18:55 -04:00
..
aggregates Make all single-fetch database calls return an Option. (#4617) 2024-04-16 14:48:15 +02:00
impls Optimize stuff in attempt to fix high amount of locks, and fix comment_aggregates.child_count (#4696) 2024-05-09 08:18:55 -04:00
source Testing for federation with NodeBB, make community.followers_url optional (#4629) 2024-04-29 12:34:11 +02:00
diesel_ltree.patch Adding a post_view mode. Fixes #3730 (#3731) 2023-08-31 09:01:08 -04:00
lib.rs Move SQL triggers from migrations into reusable sql file (#4333) 2024-04-17 20:58:44 -04:00
newtypes.rs chore: fix some comments (#4637) 2024-04-17 14:35:54 +02:00
schema.rs Testing for federation with NodeBB, make community.followers_url optional (#4629) 2024-04-29 12:34:11 +02:00
schema_setup.rs Move SQL triggers from migrations into reusable sql file (#4333) 2024-04-17 20:58:44 -04:00
traits.rs Make all single-fetch database calls return an Option. (#4617) 2024-04-16 14:48:15 +02:00
utils.rs Update rustls (#4690) 2024-05-03 16:06:14 -04:00