Re: Subversion Newbie thoughts: Database Backend, SQL, and the style?

David Weintraub wrote:
> TeamTrack uses SQL to store it's version tree. The only benefit I see
> is to be able to say that they use SQL and you can store your
> repository under Oracle or MS-SQL Server.

   One of the major benefits of having an SQL backend would actually
   be the ease that some of the currently outstanding problems could
   be solved. It's all about indexing.

   With the FSFS backend, everything is pretty much optimised for
   the current feature set. If you want suddenly, to support
   "svn lsdecendents X", that'd be pretty inefficient to solve
   with fsfs. A new index would be required and a whole swag of
   new code. With an SQL backend you can formulate new queries to
   create these kinds of features with relative ease. BDB sits
   somewhere in the middle.

   There is a diagram somewhere to this effect in the developer
   docs....

daniel

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@subversion.tigris.org
For additional commands, e-mail: users-help@subversion.tigris.org
Received on Mon Feb 27 11:23:09 2006