#579: Data Characterization - Cycle 3 Tracking
------------------------------+-------------------------
Reporter: lv | Owner: mprittie
Type: problem | Status: assigned
Priority: major | Milestone: cdm-cycle3
Component: data-stds | Resolution:
Keywords: CDM v3, DCQ, EDC | Blocked By:
Blocking: |
------------------------------+-------------------------
Comment (by hangs008):
Running the XTBL_L3_MISMATCH query takes ~12 hours through SAS at UMN. I
wrote equivalent queries directly against the DBMS and was able to gather
the results in under 4 minutes. Would it be possible to re-factor the
curation query to leverage the database engine for those of us who hold
our data in a DB? We have indices on our ENCOUNTERIDs and our PATIDs so
most of the counts can be handled directly at the index level instead of
pulling in the whole data set.
--
Ticket URL:
<http://informatics.gpcnetwork.org/trac/Project/ticket/579#comment:8>
gpc-informatics <http://informatics.gpcnetwork.org/>
Greater Plains Network - Informatics
_______________________________________________
Gpc-dev mailing list
Gpc-dev@listserv.kumc.edu
http://listserv.kumc.edu/mailman/listinfo/gpc-dev
