Skip to content

Fix rum search speed

lain requested to merge fix-rum-search into develop

The pagination led to a second 'order by' by the activity id, but the speed of the RUM index depends on the order being based on the indexed inserted_at in the objects table only, so we can do index-only scans.

This reduced search speed by a factor of about 1000. Search times for a popular search term (lain) dropped from 50 seconds to 50 milliseconds.

Merge request reports