I think it took about 30 min on single instance Oracle 12c here, definitely a matter of minutes not hours.
UTHSCSA QA query v6 https://bitbucket.org/njgraham/pcori-qa/src/7ce69cfb8f37/Q1_2015_Quality_Query_v6.sql?at=uthscsa Which is a modified version from this branch https://bitbucket.org/njgraham/pcori-qa/branch/oracle_v6 -Angela -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Tom Mish Sent: Tuesday, April 28, 2015 8:00 AM To: [email protected] Subject: Re: [gpc-informatics] #281: performance of Q1 QA query on non-Neteeza systems 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 _______________________________________________ Gpc-dev mailing list [email protected] http://listserv.kumc.edu/mailman/listinfo/gpc-dev
