Tuesday, December 20, 2011

Eclipse Performance Tuning

This is an excellent article on Eclipse Performance Tuning.  The author references a lot of other good articles too.

I am running Eclipse on Linux with the IBM 1.6 JVM.  Performance is actually good for me, but eclipse increases the load on the box and other people suffer.

Friday, December 16, 2011

UI

Software developers really need to get better at UI.  (I am working on getting better myself.)  Here's a UI Design Top Ten.

SQL Happiness

Hello SQLer's out there.

Here's a little nugget for you.  Use the join syntax.  Why?  Because it becomes super obvious what parts of the SQL is for a JOIN and what parts are for a filter.

Here's what I mean

select blah
from blah1 a, blah2 b, blah3 c, etc.
where a.field = b.field 
and a.other like 'ABC%'
and b.field = c.field

In a big SQL with more tables and more fields, you start to loose the distinction between join and filter parts of the SQL.

This is better:


select blah
from blah1 a 
inner join blah2 b on (a.field = b.field), 
inner join blah3 c on (b.field = c.field), etc.
where a.other like 'ABC%'

Don't you agree?

I made this post because I have a 20 line SQL with a filter clause hidden among the join clauses.  This is better practice.



Thursday, December 8, 2011

Wednesday, December 7, 2011

DB2 SQL Explorer

This is pretty easy to set up.

http://www.sqlexplorer.org/screenshots.php

SQL Explorer is great.  Go look at the screen shots.  It's working really well so far for me.  You have to have the DB2 universal driver and set up the jar files and driver name, but that's all.  Then connect to your DB, create a project, save your SQL file and start cranking!

Be careful of your transactions!  (I always begin tran/rollback tran/commit train it's a good habit)

Follow up

I have since found that data tools for Eclipse is just as good if not better.  It will allow you to load, unload data from a table.  Pretty handy.  See also my SO question about loading data into db2 from eclipse.

Tuesday, December 6, 2011

Window XP Mode Speedup

I'm using Windows XP mode to do a project.  It's kind of a legacy project and I know all the tools will work well on XP.  XP Mode was running really slow, but I changed the Integration Features and increased the memory.  In Integration Features I turned off everything except for clipboard integration which is hard to live without.  Performance is much better.

Thursday, December 1, 2011