Comment 1 for bug 661988

Timings are showing that BugTask.targetnamecache can no longer be queried fast enough - there are just too many bug tasks now.

launchpad_prod_3=# select count(*) from BugTask where BugTask.targetnamecache ilike '%grub%';
 count
-------
  3183
(1 row)

Time: 1668.405 ms

We can't shave this time off the queries - we need a better way of doing the substring search, or drop the substring search.

(but this isn't the whole problem)