[TYPO3-dev] TYPO3 and SubVersion?

[Jigal van Hemert]

Hi Tobias,

-----Original Message-----
From: typo3-dev-bounces at lists.netfielders.de
[mailto:typo3-dev-bounces at lists.netfielders.de] On Behalf Of Tobias
Pinnekamp
> Joerg Schoppet schrieb:
> > Jigal van Hemert wrote:
> >> Is there anyone with experience on using SubVersion with TYPO3? 
> > the only thing we managed to get in svn were the TS-Templates:
> > - Save the content of your constant-field and setup-field in
different 
> > text-fiels
> > - only include [1] the following in your templates (e.g.):
> >     <INCLUDE_TYPOSCRIPT: source="FILE: 
> > fileadmin/templates/ts/generalConfiguration/constants.txt">
> 
> that sounds intersting. But how is the performance? It is 
> recognisable slower than storing it in the database? I think 
> so, without testing it, because on every page request the 
> file must be included and read. What are your experiences?

A database is nothing more than a file with a layer of code to access
and manipulate the data in the file. You can argue that database table
are mostly accessed in memory and that it should therefore be faster.
Most OS's however use memory of webservers also to cache frequently used
files. 
So, most of the time including files will be slightly faster than
retrieving the data from a database, simply because you're eleminating
the database layer. If the database is located on a different machine,
you will also have the advantage that in most cases the files are on a
local disk. This will make database access even slower.

Regards, Jigal.