HomeMusing Studio

Add index to improve post retrieval speed on large instances

Description

Add index to improve post retrieval speed on large instances

On an instance with millions of posts across all users, a single blog with
thousands of posts on it can take a long time to render. This adds an index
to the posts table to speed up the basic GetPosts query.

Run: writefreely db migrate

Closes #741

Details

Provenance
mattAuthored on Sep 26 2023, 6:36 PM
Parents
rWFf404f7b92881: Support resetting password via email
Branches
Unknown
Tags
Unknown
References
refs/pull/778/head