DigitalOcean Machine details which was used for testing: CPU Intel Xeon 2 cores/ RAM 2GB / SSD storage drive. User Mifos demo database - http://goo.gl/pgZOsE
Main purpose was to see if running report for big amount of entries simultaneously will extremely slow down the system and cause any issues for other users.
Testing steps: 1. 4 users has logged into the system 2. 3 of them launched following report: columns: 9 measures( like Principal Amount, Approved Principal and other columns from m_loan table ). rows: Client’s display name (289 clients) 286 x 9
for all these 3 users, loading query took 5 seconds and mysqld process increased only by 65mb. 3. 4th user has not any issues working with Mifos (creating loan)
|