Issue #21 resolved

Log web page loads slowly

Jason R. Coombs
created an issue

As our database has grown to over 1M records, the response time for / on pmxbotweb is very slow (sometimes over 30 seconds).

It turns out this is due to the 'distinct' query on channel names, which is [[|known to be slow]] even when there's an index on it.

It's probably worth doing some optimization to avoid this home page loading slowly.

Comments (1)

  1. Jason R. Coombs reporter

    There has been a workaround in pmxbot for some time now where the channels list is cached for subsequent requests. This substantially improves the response time for loading the logs.

  2. Log in to comment