No, I'm not aware of any other problem reports with long runtimes. Perhaps you could give some details? Attach an XML version of your query and/or a print-query version of your query? How long is excessive? 20 minutes? 2 days? What is a typical runtime? What runtime do you get if you chop the query roughly in half?
-- Dan ________________________________________ From: Susan Morrison [[email protected]] Sent: Tuesday, April 05, 2016 2:00 PM To: [email protected]; Sravani Chandaka; Dan Connolly; [email protected]; Russ Waitman; Nathan Graham; Brittany Zschoche; [email protected]; [email protected]; [email protected]; [email protected] Subject: [gpc-informatics] #263: Adaptable cohort query design and administration UTSW is experiencing excessive runtimes. Did I miss where someone might have mentioned this? Best Regards, Susan Morrison Database Analyst Office of Academic Information Systems(AIS) 6303 Forest Park | Suite BP4.100 | Dallas, TX 75390-9106 Ph. (214)648-4295 Email:[email protected] ___________________ “One Team One Dream” On 4/5/16, 9:22 AM, "[email protected] on behalf of GPC Informatics" <[email protected] on behalf of [email protected]> wrote: >#263: Adaptable cohort query design and administration >--------------------------+--------------------------------- > Reporter: schandaka | Owner: schandaka > Type: design-issue | Status: assigned > Priority: major | Milestone: adaptable-accrual >Component: data-stds | Resolution: > Keywords: | Blocked By: 267, 444, 462, 495 > Blocking: 353 | >--------------------------+--------------------------------- > >Comment (by schandaka): > > I encountered few issues while trying to recreate the query using GPC > Ontology. > - I needed to use Creatinine>1.5 and GPC Lab values were accepting only > integers. Dan performed a quick fix in #495. > - Search by keywords doesnt seem to be working on babel. Without that it > is cumbersome to recreate the ADAPTABLE query using the GPC Ontology. As > per the discussion during 03/29/2016 gpc-dev call,this work is not > preventing any sites from working on their cohort characterization. > > After discussion with the sites, decission was made to not pursue > recreating the ADAPTABLE query using GPC Ontology.I am unable to close > this ticket because #444 and #462 are blocking. > >-- >Ticket URL: ><http://informatics.gpcnetwork.org/trac/Project/ticket/263#comment:40> >gpc-informatics <http://informatics.gpcnetwork.org/> >Greater Plains Network - Informatics >_______________________________________________ >Gpc-dev mailing list >[email protected] >http://listserv.kumc.edu/mailman/listinfo/gpc-dev ________________________________ UT Southwestern Medical Center The future of medicine, today. _______________________________________________ Gpc-dev mailing list [email protected] http://listserv.kumc.edu/mailman/listinfo/gpc-dev
