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

[Dmitry Dulepov]

Hi!

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/ 

I just found that I have two +1s for this feature but it was never committed. Now it is in trunk (with Masi's suggestions added). I attach the real patch here and to the bug report. NEWS.txt is updated too.

-- 
Dmitry Dulepov
TYPO3 Core team
My TYPO3 book: http://www.packtpub.com/typo3-extension-development/book
In the blog: http://typo3bloke.net/post-details/duplicate_content_with_realurl/
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 7059.diff
Type: text/x-diff
Size: 4498 bytes
Desc: not available
Url : http://lists.netfielders.de/pipermail/typo3-team-core/attachments/20081003/4ebf043c/attachment-0001.diff