DB Growth

Can anyone explain why we are seeing exponential growth in our
"Attachments" table?

It appears to be related to emails sent by the system, but looking for
more concise explanation.

We only have approximately 5000 tickets yet our Attachments table (we
don’t have actual attachments enabled) is growing significantly to 8GB.

Thanks,

-Stark

Check to see if a scrip is caught in a loop sending/adding attachments
to your tickets (and your db).

Forrest

Jeff Stark wrote:

Thanks Forrest,

We found that there were a couple of tickets where (somehow) the
requestor had attached the same file (roughly 5MB) over 100 times.

Thanks,

Check to see if a scrip is caught in a loop sending/adding attachments
to your tickets (and your db).

Forrest

Jeff Stark wrote:

Can anyone explain why we are seeing exponential growth in our
"Attachments" table?

It appears to be related to emails sent by the system, but looking for

more concise explanation.

We only have approximately 5000 tickets yet our Attachments table (we
don’t have actual attachments enabled) is growing significantly to
8GB.

Thanks,

-Stark



http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com Commercial support:
sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com