Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

12
  • How long - as in how much data - is each row being fetched, as a rough estimate?
    – Adam Musch
    Commented Feb 13, 2012 at 17:36
  • We're talking reading a few thousand rows several hundred times each, e.g. 10,000 rows * 500 times
    – daveslab
    Commented Feb 13, 2012 at 19:20
  • 1
    Is there a reason you're not doing that kind of heavy lifting inside the database itself?
    – Adam Musch
    Commented Feb 13, 2012 at 19:40
  • Yeah, because basically we're grabbing data from two different databases and they can't be linked at all. So we need a third party to do the comparison.
    – daveslab
    Commented Feb 13, 2012 at 21:36
  • are these 2 databases both Oracle instances? Or Oracle and some other db. If so, how do u know the issue is with pulling data from Oracle?
    – tbone
    Commented Feb 14, 2012 at 12:58