Chris Nelson wrote:
We've coming up on 3 years of use and nearly 8k tickets with many, many
attachments and it's slowing down some.  I'd be curious to hear from
other users if they have much bigger installations and how they handle
performance issues.

Hi Chris, hi Chen.

we are using Trac 0.11.6 with only approx. 500 tickets per repository, yielding a SQlite database size of 15MB. Note that attachments are not inside the SQlite file, instead they are stored as files in the "attachment" sub-directory of each repo. I would not expect the attachments to be a problem for database speed.

In another programming project we use SQlite for other purposes. We have also made stress-tests with ten-thousands of table entries and 500 MB SQlite file size. Searching was quite slow but no other problem. SQlite can safely handle such large databases.

Clemens

--
You received this message because you are subscribed to the Google Groups "Trac 
Users" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/trac-users?hl=en.

Reply via email to