[thelist] Internet Explorer 7
Maximillian Schwanekamp
lists at neptunewebworks.com
Wed Feb 16 16:57:38 CST 2005
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/
More information about the thelist
mailing list