[TYPO3-dev] Good times with MySQL 5.1

[Dan Osipov]

I wonder if it would be better for performance...

Dan Osipov
Calkins Media
http://danosipov.com/blog/

Steffen Kamper wrote:
> Hi,
> 
> in future it will be possible to parse XML with MySQL, so the door is 
> open for parsing templavoila-structure or other flexform structures 
> direct in SQL [1].
> For example extracting the uids of used contentelements of a page it 
> would be possible to use
> SELECT ExtractValue(tx_templavoila_flex, 'sDEF/lDEF/vDEF') as 
> content_uids from pages
> 
> There is also the possibility to Update Records writing single values to 
> this XML-structure.
> 
> vg Steffen
> 
> [1] http://dev.mysql.com/doc/refman/5.1/en/xml-functions.html