Tuesday, 27 January 2009

IBM iSeries (AS/400) SQL Performance

Recently I had the opportunity to test the execution time of programs which access very large files. I wrote traditional file oriented programs and equivalent ones which use instead embedded SQL.

The results are quite interesting and I have written a report which describes the tests and the results.

It shows also that a good use of SQL indexes and views can have significant benefits on the execution times.

The article was originally published on http://www.ezinearticles.com

You can read the full report at http://www.datamission.co.uk/SQLPerformance.html