[TYPO3-core] RFC: #7059: Improve database performance for external database host

[Steffen Kamper]

"Dmitry Dulepov [typo3]" <dmitry at typo3.org> schrieb im Newsbeitrag 
news:mailman.1.1198926148.18622.typo3-team-core at lists.netfielders.de...
> Hi!
>
> This is SVN patch request.
>
> Type: feature
>
> Branch: trunk
>
> BT reference: http://bugs.typo3.org/view.php?id=7059
>
> Problem: According to [1] MySQL performance may be greatly improved by 
> using compression if MySQL is on the external host and connection link 
> speed is less than 1Gbps.
>
> Solution: attached patch adds an option to TYPO3 to enable compression and 
> modifies database layer to use it for external database hosts. If host is 
> localhost, the option has no effect (because it will make situation 
> worse).
>
> [1] 
> http://www.mysqlperformanceblog.com/2007/12/20/large-result-sets-vs-compression-protocol/
>
> -- 
> Dmitry Dulepov
> TYPO3 core team
> Web: http://typo3bloke.net/
> Skype: callto:liels_bugs
> "Nothing is impossible. There are only limits to our knowledge"

+1 by reading.
While enabling this flags, would it be reasonable to integrate the other 
flags as well?
MYSQL_CLIENT_COMPRESS, MYSQL_CLIENT_IGNORE_SPACE, MYSQL_CLIENT_INTERACTIVE

vg  Steffen