Re: Berkeley DB 4.1.14 is a lot slower.

Brandon Ehle wrote:

> Marc Haesen wrote:
>
>> I have compiled svn both with db 4.0.14 and db 4.1.24 in windows
>> 2000. Both
>> seem to work fine except that the access to the svn repository 4.1.14
>> is a
>> lot slower.
>> The repository contains 46 files in 194 directories and a checkout of
>> the
>> 4.1.24 repository takes around 10 minutes (apache server in windows
>> 2000),
>> the checkout of the 4.0.14 repository takes less then a minute.
>>
>> Is there anything that I need to adjust when using 4.1.14 to avoid this
>> problem, or is this a know problem of the current software?
>>
>>
> You might try 4.1.25, I'm not sure how many developers are running
> 4.1.24 on a windows server.

4.1.25 won't help, the differences are too small. The 4.1.x versions
seem to be a lot more pedantic about syncing file writes when starting
and finishing transactions than 4.0.x. You might try to add the
following options:

    set_flags DB_TXN_NOSYNC
    set_flags DB_TXN_WRITE_NOSYNC

to the DB_CONFIG file, but be aware that this makes your database much
less robust.

This apparent slowness of BDB 4.1.x is the main reason I didn't update
my Win32 subversion builds from 4.0.x. It would be nice to see what's
going on, though, because things really shouldn't be that slow. It's
possible we're doing something fundamentally stupid in our code, of
course, although I can't imagine what.

BTW, I uploaded 4.1.25 binaries to the subversion.tigris.org file
sharing page, removing the previous 4.1.24+patches.

-- 
Brane Čibej   <brane_at_xbc.nu>   http://www.xbc.nu/brane/
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@subversion.tigris.org
For additional commands, e-mail: dev-help@subversion.tigris.org