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

Database growth concerns.

CPS, C-EMR, PM

Last Post by Anonymous 1 second ago

12 Posts

7 Users

0 Reactions

74 Views

RSS

dougmcilvaine

(@dougmcilvaine)

Posts: 7

Active Member

Topic starter

Management has concerns centricity database is growing at an abnormally high rate 200 GB a year. Is this “normal”? We started out with CPS 9.5 and are now CPS 12. Did version upgrades bring growth due to additional tables / columns? IS there anything that can be done to stem the growth rate? Purge records etc.?

Posted : March 2, 2015 9:43 am

SLHV

(@slhv)

Posts: 478

Honorable Member

Can you provide some practice info?

We're on CPS 12. We started with PM 04, then went live on EMR with CPS 06 and continued to CPS 12 now. We have 12 providers in a cardio practice. Our database is currently 37GB. It isn't growing quickly at all.

I would point out that we did not choose to store our attachments in the database specifically to avoid the database bloat. There is no significant benefit to storing attachments in the database, but there are a number of drawbacks.

Posted : March 2, 2015 10:20 am

dougmcilvaine

(@dougmcilvaine)

Posts: 7

Active Member

Topic starter

We have 100+ providers, 20k patients, 6 clinics. We do not have attachments in our database either.

Posted : March 2, 2015 10:24 am

lic08

(@lic08)

Posts: 286

Reputable Member

YEs we are experiencing the same thing too. we have about 40+ provider. Our database has grown 4 times in size since cps 9 i believed. We don't use the attachments in our db either.

Posted : March 2, 2015 10:33 am

SLHV

(@slhv)

Posts: 478

Honorable Member

My mistake. I looked at the backup size. Our .mdf is 200GB and .ldf is 235GB. That seems high to me so I'll be checking into that myself now. 🙂

Posted : March 2, 2015 10:33 am

SLHV

(@slhv)

Posts: 478

Honorable Member

Ah. Our database recovery model is currently set to full. That explains the LDF. Also, we've set our db starting sizes in MSSQL to 200GB (MDF) and 235GB (LDF) for some reason. We're only using 37GB currently.

Posted : March 2, 2015 10:52 am

twerner

(@twerner)

Posts: 82

Estimable Member

Our database started growing exponentially immediately after we upgraded to CPS 12. We are quite concerned. We have 11 providers, 3 mid-levels. We store our attachments on a completely different server. We used 50 GB in a period of 3 weeks. We thought we were set for quite some time but bright one morning last week no one could log in to Centricity because our database was full. We have virtual servers so our IT folks were able to reallocate space within minutes but we are now keeping a very close eye on our growth.

Posted : March 2, 2015 11:09 am

SLHV

(@slhv)

Posts: 478

Honorable Member

50GB over a few weeks seems quite excessive. In SSMS right click on the Centricity database, go to Reports > Standard Reports > Disk Usage by Top Tables. Perhaps one of the tables will stand out.

Posted : March 2, 2015 11:49 am

jamesedward

(@jamesedward)

Posts: 257

Reputable Member

We see similar sizing on the Oracle platform. While not every day is the same, it averages to about 1GB per day growth over time. Much seems related to auditing, formularies and eligibility. Often see spikes once monthly on a Monday night (at 10GB), after monthly updates are in.

Posted : March 3, 2015 3:52 am

twerner

(@twerner)

Posts: 82

Estimable Member

Thank you SLHV for the information on running a report. It was extremely helpful!

Posted : March 3, 2015 10:37 am

alanbaker

(@alanbaker)

Posts: 3

New Member

Lightweights...

Our database is over 850GB, yes, a smidgen away from a TERRA-BYTE.

GE has re-assured us it's fine. CPS 12 sp 7 works very efficient and there are no significant delays in any of our modules.

Posted : March 6, 2015 2:19 pm

wwalecka

(@wwalecka)

Posts: 40

Trusted Member

I have significant database issues, although we are hosted with GE and use EMR 9.8. I am still trying to figure out how I get up to a dozen duplicates of pharmacies, professional contacts, etc. It takes me almost 20 minutes to update one pharmacy or try to merge contacts since all the erroneous ones are already associated with a patient, so I cannot remove them. I dread updating any pharmacy information.

Posted : December 1, 2015 9:04 am

Share:

24 Forums
9,940 Topics
39.9 K Posts
0 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