[rt-devel] shredding users

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


Hi,

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?

Chris


More information about the rt-devel mailing list