[rt-users] [PERFORMANCE][PATCH] Searches by watchers with OR aggregator

[Ruslan Zakirov]

  Hi, guys.

Thank you for the feedback. Here is patch that should address
performance problems with queries like:
"Owner = X OR Requestor = Y"
"Requestor = Y OR Status = X"
and other queries where positive search conditions (=, like ...) on
Requestor, Cc, AdminCc or Watchers are joined with other conditions
using OR. It doesn't apply to queries with all ANDs, as well it's not
about searches by links, dates or something else. It's about watchers
and ORs.

-- 
Best regards, Ruslan.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 3.6-searches_by_watchers_performance_fix.patch
Type: text/x-patch
Size: 2158 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20070725/a290aa61/attachment.bin>