Log web page loads slowly

Jason R. Coombs avatarJason 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

    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
Tip: Filter by directory path e.g. /media app.js to search for public/media/app.js.
Tip: Use camelCasing e.g. ProjME to search for ProjectModifiedEvent.java.
Tip: Filter by extension type e.g. /repo .js to search for all .js files in the /repo directory.
Tip: Separate your search with spaces e.g. /ssh pom.xml to search for src/ssh/pom.xml.
Tip: Use ↑ and ↓ arrow keys to navigate and return to view the file.
Tip: You can also navigate files with Ctrl+j (next) and Ctrl+k (previous) and view the file with Ctrl+o.
Tip: You can also navigate files with Alt+j (next) and Alt+k (previous) and view the file with Alt+o.