Archive for May, 2009
Hey Denis, what is that on your screen?
Oh, nothing of interest.
[ Back to top ]
The Portal Gets Components
The Portal will finally fully support components/sub-sub-projects! It has been some time since we updated the development process to work with components, but our software has been lagging sadly behind. Updating all of the code has been a big project as there are so many changes that needed to be made to integrate this everywhere. [...]
[ Back to top ]
Optimizing SQL: maximizing query cache
Today’s topic is focused on getting the most out of MySQL’s query cache. Query cache isn’t on by default, so if your servers aren’t using it, you’re missing out.
Let’s look at how the query cache works. Witness a query I’ve used before:
select translation_id from translations where string_id in
(select string_id from strings [...]
[ Back to top ]
Optimizing SQL Part 2: the size of your queries
The size and complexity of a SQL query can greatly influence its execution time. Since MySQL 5.0, subselects are now supported, but I often see SQL novices overuse subselects with disastrous results.
For instance, consider these queries I use in Babel. For accurate results, I ran all the queries once, then cleared the query cache, then [...]
[ Back to top ]
Optimizing SQL: Part 1 - minimizing connections and query counts
www.eclipse.org is a pretty busy site, and for the most part, it’s well optimized and quite fast. I’m not talking about Bugzilla or CVS here, only www.eclipse.org.
I’m a big fan of profiling and optimizing. Perhaps this is because I learned to program on a Timex Sinclair 1000 with 2KB of RAM, where Every Byte Counts!
In [...]
[ Back to top ]
Favorite Linux IDE
My latest copy of the Linux Journal (yeah, an actual magazine, printed on paper… with ink), featuring the Readers’ Choice Awards 2009, shows Eclipse as the winner of the Favorite Linux IDE award. This quote sums it up:
“In Eclipse, one can work in a lean environment and add and subtract an incredible array functionality with [...]
[ Back to top ]
Eclipse 3.5M7 torrents
I’ve just put some Bit Torrents up for 3.5M7:
http://build.eclipse.org/technology/phoenix/torrents/SDK/stable/
Enjoy!
[ Back to top ]
