Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine

Re^2: Space Efficiency of Hashes

by Anonymous Monk
on Mar 16, 2005 at 03:40 UTC ( #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.

Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://439851]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others browsing the Monastery: (2)
As of 2022-08-10 14:16 GMT
Find Nodes?
    Voting Booth?

    No recent polls found