#3760 Age-Sex Report

[Shehzad Merchant]

build date: Apr 24, 2014 3:39:42 PM
build tag: 12.1.1.51general390
Client browser: FireFox ESR 24.6.0
Client OS: Windows 7

Preconditions:
Please provide all information needed before this issue will present

Select the option 'Age-Sex Report' from Administrative Page --> Oscar Report Section.
'Demograhpic' table contains more than 15,000 records

Steps to reproduce:

1) ‘demograhpic’ table contains more than 15,000 records.
2) When the report is selected before displaying the page ’oscarReportAgeSex.jsp’, it individually copies the records from Demographic Table to ‘reportagesex’ table.
3) It takes approximately take 15 minutes to display the page.

Expected Result:
Improve the efficiency of the report by modifying the methodology to copy the records from demographics table to reportagesex.

Instead of before page loading, It should be compiled the report on the basis of selection criteria.

Observed:
Slow performance of the report / option

[SBek]

Unable to replicate the issue locally in Release 12_1 but checked on the production environment that runs on Master and contains high volume of records in the system. Confirm that the age sex report performance is slow in Master as well.

The performance should be revised in both Trunk and Release 12_1.

[RJAV]

Hi Suni Bek, i have a doubt regarding oscarm emr 12.1.1., we have deployed but still confusing which is the stable version? if there chance can you help me! and i am also looking for Quality assurance team ?