Improve device mgt core performance #394
Merged
pahansith
merged 6 commits from improvement/dm-performance
into master
6 months ago
Loading…
Reference in new issue
There is no content yet.
Delete Branch 'improvement/dm-performance'
Deleting a branch is permanent. It CANNOT be undone. Continue?
When device count is exceeding more than 300,000 DM_DEVICE table and DM_ENROLMENT table related queries are taking more than 30s to execute. In order to resolve this downgraded DB normalization level to 2 from 3 and added DEVICE_TYPE and DEVICE_IDENTIFICATION columns to DM_ENROLMENT table, in order to minimize the requirement of joining DM_DEVICE table always for DM_ENROLMENT related queries.
Data migration:
0f58c484f0
to7c0df33738
6 months ago9517e80939
into master 6 months ago9517e80939
.