Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

Notifications

Clear all

EMR 9.8.10 Archive_Obs

Page 2 / 2 Prev

CPS, C-EMR, PM

Last Post by Anonymous 1 second ago

25 Posts

5 Users

0 Reactions

136 Views

RSS

codyh3

(@codyh3)

Posts: 61

Trusted Member

Topic starter

I ran the select count(*) from obs and got 28,571,890. So we do have a ton of them in there.

Posted : September 23, 2015 5:12 am

rwilliams

(@rwilliams)

Posts: 454

Honorable Member

We have 48,284,579 and do not have speed issues so it is all in the configuration and hardware that you use.

Posted : September 23, 2015 5:15 am

codyh3

(@codyh3)

Posts: 61

Trusted Member

Topic starter

Now another question... The person that set our EMR up in the beginning has the DB and JBOSS on the same server... GE doesn't recommend this setup over 50 users. We have 65. Is it difficult to move the JBOSS part of the EMR to another server?

Our CPS (for PM only) has a SQL server and then the application server is separate. We never have issues with slowness or anything really with CPS.

Posted : September 23, 2015 5:22 am

rwilliams

(@rwilliams)

Posts: 454

Honorable Member

If you are experiencing performance issues with your DB and you are not running on SSD drives, I would HIGHLY recommend the switch. A single SSD drive usually has more IOPS than 20-30 spinning disks. Since you would never have a single drive for anything, running that drive in a R5 or R10 array of them is that much faster.

Posted : September 23, 2015 5:35 am

rwilliams

(@rwilliams)

Posts: 454

Honorable Member

I do not know what the process would be to separate app and db but I do not imagine it would be terribly difficult. To determine if you need it, take a look at the CPU and memory usage on the server. If they are high, it might be time to separate. Disk IO would be another (major) bottleneck but it is slightly more difficult to determine if that is your issue. (you would have to know what your IO capabilities were when nothing was running and then determine what it was running at during peak load)

Posted : September 23, 2015 5:40 am

rwilliams

(@rwilliams)

Posts: 454

Honorable Member

One more thought. When we were having speed issues (due to our snapshots) GE provided us with a script they called "getstatistics" which went really in depth to tell you what was slowing down your server. You really need a DBA to look at the output to give you an idea of what the output means. Open a case with them and see if you can get someone (preferably Hillary Hart, she knows it inside and out) to provide the script to you and interpret the output.

I might be able to locate the script but again, unless you know what you are looking for, it will not do much good.

Posted : September 23, 2015 5:53 am

codyh3

(@codyh3)

Posts: 61

Trusted Member

Topic starter

If I call into GE's Platform group is Hillary a part of that group?

Posted : September 23, 2015 5:56 am

rwilliams

(@rwilliams)

Posts: 454

Honorable Member

She is a DBA that works in the group. She is not a front line support person but if you open a ticket with support and mention that you are looking for that script and she was the one that provided it to us you might be able to have them pull her in as a resource.

Posted : September 23, 2015 7:15 am

codyh3

(@codyh3)

Posts: 61

Trusted Member

Topic starter

I went ahead and started Archiving these a few days ago. Since then our performance has actually greatly improved (knock on wood). We were able to archive roughly 10k charts observations. Any chart that had over 1000 obs were set to archive and only keep 500 at a time.

Thank you for everyone's input on this!

Posted : September 24, 2015 7:27 am

Marketing Committee

(@marketing_committee)

Posts: 358

Reputable Member

Good news, thanks for letting us know.

Posted : September 24, 2015 7:34 am

Page 2 / 2 Prev

Share:

24 Forums
9,940 Topics
39.9 K Posts
4 Online
6,470 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo Powered by wpForo version 2.4.0