Are there benchmarks about the usage, speed, reliability of svn back-end databases?
SQLint
MySQL
PostgreSQL
BarkleyBD
Flatfile system
lets say we have 20 people working on the repository concurrent. What to choose?
views:
65answers:
2
+5
A:
The FSFS backend is the most well-tested and stable of the lot. For only 20 people, you are not likely to have any performance problems at all.
Greg Hewgill
2009-09-04 09:54:44
+5
A:
You only have 2 choices: BDB (BerkeleyDB), or FSFS (direct filesystem)
These days, there is almost no advantage to BDB, and I think it is only around for legacy compatibility. FSFS is the default on any current SVN release. A lot of the SVN binary distributions don't even have BDB support compiled in.
More info: http://svnbook.red-bean.com/en/1.5/svn.reposadmin.planning.html#svn.reposadmin.basics.backends
msemack
2009-09-04 15:39:08
Now where was it that I thought I read that recent versions of Subversion supported more backends than just BDB and FSFS? I just checked the release notes for 1.6.x and there was no mention of other backends (except for SQLite for other purposes), so I must have been mistaken. Regardless, today I wouldn't choose anything but FSFS even if there were others available.
Greg Hewgill
2009-09-04 20:17:59