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

[Dmitry Dulepov [typo3]]

This is a reminder. There was a long discussion on it but no decision. If there are no +1s, I will close this bug as "won't fix" because it stays open for too long.

Dmitry Dulepov [typo3] wrote:
> 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"