Keep us posted on the performance. We actually picked up an oracle partitioning license here but would be great to see benchmarks.
Russ -----Original Message----- From: Taylor, Bradley <btay...@mcw.edu> Sent: Thursday, August 02, 2018 10:33 AM To: Russ Waitman <rwait...@kumc.edu>; PCORnet DRN OC <dr...@pcornet.org>; Osinski, Kristen <kosin...@mcw.edu>; Kowalski, George <gkowal...@mcw.edu>; Laurel Verhagen <verhagen.lau...@mcrf.mfldclin.edu>; GPC-DEV@LISTSERV.KUMC.EDU Cc: Allison Haufler <allison.hauf...@duke.edu>; Laura Qualls <laura.qua...@duke.edu>; Darcy Louzao, Ph.D. <darcy.lou...@duke.edu> Subject: Re: Med Coll Wisconsin's r008 approved Thank you Russ… Wine and Brie might be more apropos. In addition to the CDM update, this was a huge move for our pipeline to Postgres taking advantage of partitioning, which will pay big dividends moving forward. From: Russ Waitman <rwait...@kumc.edu> Date: Thursday, August 2, 2018 at 7:51 AM To: PCORnet DRN OC <dr...@pcornet.org>, "Osinski, Kristen" <kosin...@mcw.edu>, George Kowalski <gkowal...@mcw.edu>, Laurel Verhagen <verhagen.lau...@mcrf.mfldclin.edu>, Bradley Taylor <btay...@mcw.edu>, "GPC-DEV@LISTSERV.KUMC.EDU" <GPC-DEV@LISTSERV.KUMC.EDU> Cc: Allison Haufler <allison.hauf...@duke.edu>, Laura Qualls <laura.qua...@duke.edu>, "Darcy Louzao, Ph.D." <darcy.lou...@duke.edu> Subject: Re: Med Coll Wisconsin's r008 approved ATTENTION: This email originated from a sender outside of MCW. Use caution when clicking on links or opening attachments. ________________________________ Congratulations Milwaukee and enjoy a malty beverage with cheese curds for us in celebration! Russ From: PCORnet OC <dr...@pcornet.org> Date: Thursday, August 2, 2018 at 9:40 AM To: Kristen Osinski <kosin...@mcw.edu>, "gkowal...@mcw.edu" <gkowal...@mcw.edu>, "'VERHAGEN. edu'" <verhagen.lau...@mcrf.mfldclin.edu>, Russ Waitman <rwait...@kumc.edu> Cc: Allison Haufler <allison.hauf...@duke.edu>, Laura Qualls <laura.qua...@duke.edu>, Darcy Louzao <darcy.lou...@duke.edu> Subject: Med Coll Wisconsin's r008 approved Good morning. I’m happy to report that C4MCW's data curation query response for refresh 8 was approved. Please retain a static, locked copy of the SAS version of the characterized tables and use these data when responding to SAS queries issued by the DRN OC or study teams, unless instructed otherwise. You may update the SAS version of the HARVEST Table and the PCORNET_TRIAL Table, as well as your RDBMS DataMart as needed. Please contact the DRN OC if an off-cycle refresh is required for any of the tables except for the HARVEST and PCORNET_TRIAL tables. Thanks, DRN OC Data Curation Team _______________________________________________ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu http://listserv.kumc.edu/mailman/listinfo/gpc-dev