You are viewing an historical archive of past issues. Please report new issues to the appropriate project issue tracker on GitHub.

Bug #2143: Model saving is slow due to lack of necessary indexes on the needles table

Kind bug
Product wincent.dev
When
Status closed
Reporter Greg Hurrell
Tags no tags

Description

When we save a searchable record, we blow the associated data away from the needles table, but it's slow due to a lack of indices (it has to do a full scan of 600k rows).

This normally doesn't matter too much, but it is noticeably slow for batch jobs, and would be nice to make it responsive for interactive use as well, even if content creation is a relatively infrequent occurrence.

Comments

  1. Greg Hurrell

    Done.

  2. Greg Hurrell

    Status changed:

    • From: new
    • To: closed
  3. Greg Hurrell

    I can confirm that editing operations are much faster now. Nice.

Add a comment

Comments are now closed for this issue.

Menu