Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot

Re^2: Space Efficiency of Hashes

by Anonymous Monk
on Mar 16, 2005 at 03:40 UTC ( [id://439851] : note . print w/replies, xml ) Need Help??

in reply to Re: Space Efficiency of Hashes
in thread Space Efficiency of Hashes

Oh I totally agree. This code is being ported from an Oracle server running on a dual-processor PC to DB2 running on a 20+ processor, 16 GB machine and yet performance has degraded incredibly. The table definitions and indices are identical, but I don't have any access privileges on DB2 to tune things so... this is a definite second choice until they get their act together.

Replies are listed 'Best First'.
Re^3: Space Efficiency of Hashes
by Tanktalus (Canon) on Mar 16, 2005 at 04:12 UTC

    Let me guess ... and it's the same (Oracle) DBA who is helping tune your DB2 system. Different RDBMS, different magnitude of hardware ... same approach? If I were talking to the DBA, I would suggest asking IBM for help in tuning the migration. If I were the DBA, I would have tried to get that tuning in before plunking down the money. However, as neither case applies, the best you likely could do is suggest to the DBA that s/he talks to IBM, and suggest it in such a way that it sounds like the DBA's idea.