Besides KUMC, did anyone else happen to note how long the query took to
run at each site? I'd especially love to hear from MCW with their
postges site.
-TM
On 4/28/2015 7:50 AM, GPC Informatics wrote:
#281: performance of Q1 QA query on non-Neteeza systems
--------------------------+----------------------------
Reporter: mish | Owner: mish
Type: problem | Status: new
Priority: minor | Milestone: data-quality3
Component: data-sharing | Resolution:
Keywords: | Blocked By:
Blocking: |
--------------------------+----------------------------
Description changed by mish:
Old description:
cf 21 Apr discussion (#12)
''Dan, reporting for Tom, who will presumably elaborate the description
in due course.''
New description:
Nathan Graham reports run time of over 17 hours on an Oracle system that
took only 15-20 minutes to complete on Netezza. Other users anecdotally
reported long times as well.
It should be runnable on: Oracle, Netezza, postgres, and MS SQL systems. I
suspect that solving the problem for Oracle solves it for most systems.
--
--
Ticket URL:
<http://informatics.gpcnetwork.org/trac/Project/ticket/281#comment:1>
gpc-informatics <http://informatics.gpcnetwork.org/>
Greater Plains Network - Informatics
_______________________________________________
Gpc-dev mailing list
[email protected]
http://listserv.kumc.edu/mailman/listinfo/gpc-dev
