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

[Xavier Perseguers]

Hi,

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.

Cheers
Xavier