[Trac] Database size

[Christian Boos]

Lewis Gardner (TYCO) wrote:

>Does the size of the (SQLLite) database depend on the size of the subversion
>repository? I have created a new Trac project pointing it to an existing,
>fairly large subversion repository and a) the indexing operation took 10
>minutes and b) the resulting database was 78MB. This also causes the web
>  
>
That's normal. There are two SVN related tables that are used to cache 
some information from
the repository, in order to speed things up...

>interface to be so slow that I regularly get timeouts.
>  
>
... so this is not normal, 78Mb should not be ''big'' for SQLite, though 
my DBs are not
that big (20Mb on average) so I can't say for sure, but my guess is that 
the size of
your database is certainly not the problem.

>Have I stumbled over a Trac limitation or did I do something very wrong?
>  
>
I guess we need more information in order to figure out what's the 
reason for
this slowness: Trac version, SQLite version, which requests ends in a 
time-out,
were there errors in the Trac log (with log_level = DEBUG in your 
trac.ini) after those queries?

-- Christian