Launchpad itself

  1. Bug #867941
  2. Comment #5

Comment 5 for bug 867941

Revision history for this message
Raphaël Badin (rvb) wrote : Re: +activereviews times out

jtv found that using a temporary table with an index in lieu et place of the CTE improves things quite significantly:
https://pastebin.canonical.com/55838/. The temp tables takes ~1s to setup and the main query now takes ~200ms (https://pastebin.canonical.com/55836/).

This is pretty amazing but it means that we would have to use the master store to be able to create the temporary table.