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

[Dmitry Dulepov [typo3]]

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"
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: mysql_ext_db_perf.patch
Url: http://lists.netfielders.de/pipermail/typo3-team-core/attachments/20071229/e4e7241f/attachment.txt