Hi Terry and Reatanak, It's no problem to share our stats. They are public information. They are on the OpenMRS website somewhere, but they are a little bit outdated there. Eventually, there will be a module that will allow the uploading of stats like that directly to OpenMRS. https://wiki.openmrs.org/display/projects/Atlas+Module+%28Design+Page%29
https://tickets.openmrs.org/browse/TRUNK-273 I used to run out of memory all the time with tomcat. I did several things to compensate for that. 1.) We stopped using InfoPath forms (and the Form Entry Module), which allows us to assign more memory to tomcat. Here is what our CATALINA_OPTS variable looks like... CATALINA_OPTS="-Djava.library.path=/usr/local/apr/lib -Xms6144m -XX:PermSize=3072m -XX:MaxPermSize=3072m -XX:NewSize=2048m" 2.) We have an automatic restart of tomcat scheduled twice a week as preventative maintenance. 3.) When doing upgrades, I stop all the modules, then un-deploy OpenMRS in the tomcat manager, then I restart tomcat, then I deploy the new war file, and finally restart tomcat again before running the database updates. 4.) Set our data exports to "Slowest time to generate, least memory used". FYI: our server has 12GB of RAM. We have lots of people using OpenMRS simultaneously, but only one implementation of OpenMRS (no synchronization). I don't think we know exactly what the maximum number of patients/encounters/observations that can be stored in OpenMRS. This is highly dependent on hardware, and what your tolerance is for slowness. We at HAS Haiti have continually pushed the OpenMRS community to handle a large number of patients, but there are others with more observations than us, and there are implications planning for more patients than us too. Thanks, James -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Mean Reatanak Sambath Sent: Wednesday, August 03, 2011 7:53 PM To: [email protected] Subject: Re: [OPENMRS-IMPLEMENTERS] Max number of records in an OpenMRS implementation Yes, that will great. I have other question for the implementation-do you any problem of tomcat out of memory when you deploy module or update database? API does it ok to add or remove. Some API of OpenMRS? Do you connect multiple OpenMRS at many place and work at same time? Thanks ----- Original Message ----- From: [email protected] <[email protected]> To: [email protected] <[email protected]> Sent: Wed Aug 03 19:32:03 2011 Subject: Re: [OPENMRS-IMPLEMENTERS] Max number of records in an OpenMRS implementation Hi sambath, Terry Hannan in Australia. May I use these stats to send to colleagues in Australia ? On 04/08/2011, at 9:03, "Mean Reatanak Sambath" <[email protected]> wrote: > Thanks. What you expect max number or data storage of OpenMRS? 10 millions? > > ----- Original Message ----- > From: [email protected] <[email protected]> > To: [email protected] > <[email protected]> > Sent: Wed Aug 03 11:25:14 2011 > Subject: Re: [OPENMRS-IMPLEMENTERS] Max number of records in an > OpenMRS implementation > > Hi Sambath, > > Our current stats are as follows (which includes voided/dead > patients)... > > SELECT count(*) FROM `patient`; > 741606 - patients > > SELECT count(*) FROM `person`; > 742632 - persons > > SELECT count(*) FROM `encounter`; > 1,471,187 - encounters > > SELECT count(*) FROM `obs`; > 7,643,004 - observations > > Thanks, > James Arbaugh > Hospital Albert Schweitzer Haiti > > P.S. I included the SQL commands too in case you want to see how I > got the numbers. > > P.S.S. There are other implementations with more observations than > us, but we're constantly gaining. > > -----Original Message----- > From: [email protected] [mailto:[email protected]] On > Behalf Of msambath > Sent: Wednesday, August 03, 2011 9:04 AM > To: [email protected] > Subject: Re: [OPENMRS-IMPLEMENTERS] Max number of records in an > OpenMRS implementation > > Hi James, > I read this message, like to know number of patients in OpenMRS > database there, how many now? > > Thanks > Sambath > > -- > View this message in context: > http://openmrs-mailing-list-archives.1560443.n2.nabble.com/Max-number- > of -records-in-an-OpenMRS-implementation-tp4662224p6648626.html > Sent from the Implementers mailing list archive at Nabble.com. > > _________________________________________ > > To unsubscribe from OpenMRS Implementers' mailing list, send an e-mail > to [email protected] with "SIGNOFF openmrs-implement-l" in > the body (not the subject) of your e-mail. > > [mailto:[email protected]?body=SIGNOFF%20openmrs-implement-l > ] _________________________________________ > > To unsubscribe from OpenMRS Implementers' mailing list, send an e-mail to [email protected] with "SIGNOFF openmrs-implement-l" in the body (not the subject) of your e-mail. > > [mailto:[email protected]?body=SIGNOFF%20openmrs-implement-l > ] > > _________________________________________ > > To unsubscribe from OpenMRS Implementers' mailing list, send an e-mail to [email protected] with "SIGNOFF openmrs-implement-l" in the body (not the subject) of your e-mail. > > [mailto:[email protected]?body=SIGNOFF%20openmrs-implement-l > ] Want to Get Healthy? The Tasmania Government's Get Healthy Information and Coaching Service provides free information and coaching support to Tasmanian adults who would like to learn healthier eating habits, be more active or achieve and maintain a healthy weight. Call 1300 806 258 between 8am and 8pm, Monday to Friday or visit www.gethealthy.tas.gov.au for more information. CONFIDENTIALITY NOTICE AND DISCLAIMER The information in this transmission may be confidential and/or protected by legal professional privilege, and is intended only for the person or persons to whom it is addressed. If you are not such a person, you are warned that any disclosure, copying or dissemination of the information is unauthorised. If you have received the transmission in error, please immediately contact this office by telephone, fax or email, to inform us of the error and to enable arrangements to be made for the destruction of the transmission, or its return at our cost. No liability is accepted for any unauthorised use of the information contained in this transmission. If the transmission contains advice, the advice is based on instructions in relation to, and is provided to the addressee in connection with, the matter mentioned above. Responsibility is not accepted for reliance upon it by any other person or for any other purpose. _________________________________________ To unsubscribe from OpenMRS Implementers' mailing list, send an e-mail to [email protected] with "SIGNOFF openmrs-implement-l" in the body (not the subject) of your e-mail. [mailto:[email protected]?body=SIGNOFF%20openmrs-implement-l] _________________________________________ To unsubscribe from OpenMRS Implementers' mailing list, send an e-mail to [email protected] with "SIGNOFF openmrs-implement-l" in the body (not the subject) of your e-mail. [mailto:[email protected]?body=SIGNOFF%20openmrs-implement-l] _________________________________________ To unsubscribe from OpenMRS Implementers' mailing list, send an e-mail to [email protected] with "SIGNOFF openmrs-implement-l" in the body (not the subject) of your e-mail. [mailto:[email protected]?body=SIGNOFF%20openmrs-implement-l]
