in reply to putting the return value from defined for one hash as the value in another

Moron:

This isn't an answer to your question, just an observation.

Looking at the code you have, you might make things a bit simpler if you let the database do more of the work. All databases (that I'm familiar with) allow you to do a left join, so you can return all your data in one SQL statement, rather than two. Something like:

SELECT L.key, L.blah1, R.key, R.blah2 FROM FirstTable AS L LEFT JOIN SecondTable AS R ON R.key = L.key
Then you can read the result, placing all items in %abs, and also placing them into %ilb if the R.key column happens to be null--or more simply, not equal to L.key.

...roboticus

Replies are listed 'Best First'.
Re^2: putting the return value from defined for one hash as the value in another
by Moron (Curate) on Apr 19, 2007 at 12:38 UTC
    You are right of course, but the last time I tried that I found a 1000 or so times performance improvement by doing the join in Perl instead of the database. Oracle seems to be particularly slow at outer joins.
    __________________________________________________________________________________

    ^M Free your mind!