2012/3/26 Elmar Teitge <elmar.teitge_at_ultra-it.de>:
> Hello Konstantin,
>
> thanks for your response.
>
> I have done a new trial for checking out the repository ...
>
> Two folders were checked out, the branches and the sandbox folder ... I I
> tried again dumping the content of the sandbox folders by "update to
> revision" with option "only this item" ... that was running about 5 hours,
> than I cancelled this process in the update dialog ...
>
> I had a look in the .svn folder and found out, that the SQLite database file
> was 570 MB in size !
>
> So I decided to do an experiment and deleted all pristine content and all
> the files in the working copy folders ... in the next step I have done the
>
> clean-up process like you described it ...
>
> After the clean-up process, the database file is still 570 MB large ...
>
> ... and an update process with "only this item" is still in progress with no
>
> result ...
>
> I am sure, that my problem is caused by a bug.
>
> But how to do a trace, that helps to find that bug ?
>
What you mean by a bug? That database access when database is stored
on a solid state drive is slow? I would say it is not a bug, it is
physics.
In essence I would say that there are many small transactions and each
updates the database, and writes are slow.
If you want to dig further
1) look for SQLite knowledge. There are some subtle ways how the
database can be tuned. It is some specific subject and I cannot help
you with it.
2) look at the mailing lists at subversion.apache.org and their archives .
Performance of working copy operations is sometimes discussed there.
Though usually people are faced with it when trying to work over
network (e.g. client running on Windows accessing wc stored on a
network drive somewhere). That is one more scenario where performance
is known to be poor.
3) the database size of 500 Mb is bad. You have too many single files
to manage. :/
As I mentioned, svn cleanup would not shrink it. There exist some
sqlite commands that can claim unused space in a database file, but
you would need an sql client to execute them, not svn client.
Best regards,
Konstantin Kolinko
------------------------------------------------------
http://tortoisesvn.tigris.org/ds/viewMessage.do?dsForumId=4061&dsMessageId=2940714
To unsubscribe from this discussion, e-mail: [users-unsubscribe_at_tortoisesvn.tigris.org].
Received on 2012-03-26 16:53:56 CEST