AMPATH 1.9 Testing

classic Classic list List threaded Threaded
3 messages Options
Manu Tars Manu Tars
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

AMPATH 1.9 Testing

Hi Daniel,
The sql dump file generated by the release test module is 12G. Our data base size show the following size

49401864    ./obs.ibd
15577092    ./hl7_in_archive.ibd
1421316    ./encounter.ibd
770052    ./person_attribute.ibd
327680    ./idcards_generated_identifier.ibd
241664    ./person_name.ibd
188416    ./patient_identifier.ibd
159744    ./formentry_error.ibd

obs hl7 and encounter are the biggest, if the size of these could be reduced in the sql dump then it may make it possible for us to import the file to 1.9 stand alone for testing

Thank you

Manu
Ampath

[hidden email] from OpenMRS Implementers' mailing list
Wyclif Luyima-2 Wyclif Luyima-2
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: AMPATH 1.9 Testing

Having almost 50 million obs and 15 million encounters for only 100 patients, i think there is something wrong with the script that copies data from the production database.

Wyclif

On Fri, May 18, 2012 at 2:25 AM, Manu Tars <[hidden email]> wrote:
Hi Daniel,
The sql dump file generated by the release test module is 12G. Our data base size show the following size

49401864    ./obs.ibd
15577092    ./hl7_in_archive.ibd
1421316    ./encounter.ibd
770052    ./person_attribute.ibd
327680    ./idcards_generated_identifier.ibd
241664    ./person_name.ibd
188416    ./patient_identifier.ibd
159744    ./formentry_error.ibd

obs hl7 and encounter are the biggest, if the size of these could be reduced in the sql dump then it may make it possible for us to import the file to 1.9 stand alone for testing

Thank you

Manu
Ampath

[hidden email] from OpenMRS Implementers' mailing list


[hidden email] from OpenMRS Implementers' mailing list
Darius Jazayeri-2 Darius Jazayeri-2
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: AMPATH 1.9 Testing

Remember that you added a feature to bring the patient with the most encounters and most observations? Could there be a test patient with an absurd number of observations?

-Darius (by phone)

On May 18, 2012 6:15 AM, "Wyclif Luyima" <[hidden email]> wrote:
Having almost 50 million obs and 15 million encounters for only 100 patients, i think there is something wrong with the script that copies data from the production database.

Wyclif

On Fri, May 18, 2012 at 2:25 AM, Manu Tars <[hidden email]> wrote:
Hi Daniel,
The sql dump file generated by the release test module is 12G. Our data base size show the following size

49401864    ./obs.ibd
15577092    ./hl7_in_archive.ibd
1421316    ./encounter.ibd
770052    ./person_attribute.ibd
327680    ./idcards_generated_identifier.ibd
241664    ./person_name.ibd
188416    ./patient_identifier.ibd
159744    ./formentry_error.ibd

obs hl7 and encounter are the biggest, if the size of these could be reduced in the sql dump then it may make it possible for us to import the file to 1.9 stand alone for testing

Thank you

Manu
Ampath

[hidden email] from OpenMRS Implementers' mailing list


[hidden email] from OpenMRS Implementers' mailing list

[hidden email] from OpenMRS Implementers' mailing list
Loading...