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

[ries van Twisk]

Hey Dmitry,

when I read this:

 >> The bottom line: if you’re fetching big result sets to the client,  
and client and MySQL are on different boxes,
 >> and the connection is 100 Mbit, consider using compression.

I kinda get the impression that it indeed works for large result sets,
but TYPO3 does a large number of small result sets so my best guess is  
that it will
not matter that much for TYPO3 websites?

PS I didn't see the discussion anywhere, happen to have a link?

Ries

On May 12, 2008, at 9:20 AM, Dmitry Dulepov [typo3] wrote:

> 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/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.netfielders.de/pipermail/typo3-team-core/attachments/20080512/3f015d04/attachment.htm