Speed improvement suggestion

  • Resolved janousekmi

    (@janousekmi)


    2 years, 4 months ago

    Hi, I would like to start by thanking you for this plugin. It works really great.

    Today I was dealing with search speed degradation and found out that a problem was in search query logging. More specifically selecting previous searches for the same session_id.

    Problem was that I have over 5 million records in log table and it took over 1 second to find all logs with a specific session_id.

    Solution was quiet simple, just adding an index to the session_id column. Now the problematic db query dropped under a millisecond.

    Maybe you can add it in future version of your plugin.

    Thanks for your good work.

Viewing 1 replies (of 1 total)
  • Plugin Author Mikko Saari

    (@msaari)

    2 years, 4 months ago

    Thanks. Sure, I’ll add this to a future version. In general, having five million records in the log table is not great for performance, and I recommend using the automatic log trimming to keep the log smaller. If you want to keep the old logs, you can export them regularly.

Viewing 1 replies (of 1 total)

The topic ‘Speed improvement suggestion’ is closed to new replies.