[thelist] Internet Explorer 7

[Maximillian Schwanekamp]

Rob Smith wrote:
> Agreed. I perused through the Blog while people are congratulating them on
> the new security fixes, a LOT of people used this opportunity to complain
> about the lack of support for web standards. 

People use every single post in the IE Blog to complain, what's new? 
Security fixes are wonderful, fantastic, [add favorite superlative 
here], esp if you happen to be a sysadmin.  As a developer, I would like 
to see changes that affect my world in a positive way.  From the looks 
of it, that's not going to happen, and

> My apologies for opening this discussion in the list as it borders on
> thechat.

Good point.

<tip type="MySQL 4 Query Caching" author="Max Schwanekamp">
After optimizing your SQL statements, perhaps the single most effective 
server tweak you can do for MySQL 4 performance is to enable the Query 
Cache.  This enables MySQL to cache query results, significantly 
speeding up repetitive queries.  This is especially effective on tables 
that get lots of SELECTs and get updated infrequently (e.g. products, 
article content, etc).

To enable query caching, add a few lines in your my.cnf (4.0.x) or 
my.ini (4.1+) like this:
query_cache_type = 1
query_cache_limit = 2M
query_cache_size = 20M

These values can vary widely depending on your server config; In MySQL 
4.1, there are some additional values you can tweak as well.

Details:
http://www.databasejournal.com/features/mysql/article.php/3110171
http://dev.mysql.com/doc/mysql/en/query-cache.html
</tip>

-- 
Maximillian Von Schwanekamp
http://www.neptunewebworks.com/