[rt-devel] shredding users

Christian Loos cloos at netcologne.de
Thu Jul 17 09:07:57 EDT 2014


shredding users, the longest database part was this query:
SELECT main.* FROM Attachments main  WHERE (main.Creator = '123')  ORDER
BY main.id ASC

Beside maybe mentioning an index on Attachments.Creator for shredder and
maybe omit the sorting, wouldn't it be better to "SELECT main.id FROM
Attachments ..." which wouldn't send the Content column?


More information about the rt-devel mailing list