shredding users
Christian Loos <[email protected]>
| Newsgroups | gmane.comp.bug-tracking.request-tracker.devel |
|---|---|
| Message-ID | <[email protected]> |
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 -- RT Training - Boston, September 9-10 http://bestpractical.com/training