[TYPO3-core] [TYPO3-v4] Re: FYI: Raised DBAL version to 1.2.0alpha2

[Ernesto Baschny [cron IT]]

Xavier Perseguers schrieb am 21.09.2010 19:37:

> FYI, DBAL version was raised to 1.2.0alpha2 on trunk for upcoming
> release of TYPO3 4.5 alpha2.
> 
> rev. 8835
> 
> What changed:
> 
> - QueryCache branch was merged into trunk meaning that prepared queries
> are now cached!
> 
> How to set up:
> 
> $TYPO3_CONF_VARS['SYS']['useCachingFramework'] = 1;
> 
> This line makes prepared queries cached into a TransientMemoryStorage.
> In short, your prepared queries are cached for the HTTP query lifetime.
> This means that a prepared query that is issued multiple times will take
> advantage of the caching but that quite limited. Still, you should get a
> (really) slightly faster user experience, at least with current usage of
> prepared queries in Core.
> 
> If you want to really take advantage of it, you need one or more
> memcached server(s):
> 
> $TYPO3_CONF_VARS['SYS']['useCachingFramework'] = 1;
> $TYPO3_CONF_VARS['SYS']['caching']['cacheConfigurations']['dbal'] = array(
>         'backend' => 't3lib_cache_backend_MemcachedBackend',
>         'options' => array(
>                 'servers' => array('localhost:11211', 'otherhost:11211',
> 'thirdhost:11211'), // port is mandatory!
>         )
> );
> 
> This way, prepared queries will be cached purely and simply!
> 
> I hope that prepared queries will get added until 4.5.0 because it's now
> really a matter of how many queries that are run again and again to
> generate a page are converted to prepared queries to get DBAL quicker.

Nice Xavier! Would you mind spending some minutes summarizing the change
in a paragraph in NEWS.txt for the alpha2 release?

It only affects installations with DBAL accessing some non-MySQL
database, right?

Wouldn't that also work with a filebackend (available for "free" on
every installation)? Or would the performance hit on accessing files
overrun the gain from caching the parsing?

And I think the "performance profiles" will now have a good time
figuring out which queries are the top candidates to convert to prepared
queries.

Thanks a lot for your very reliable work done so far!

Follow-ups to typo3.projects.v4 please.

Cheers,
Ernesto