Forums | Mahara Community
Latency smarty header_logo_small
03 May 2019, 3:25 AM
03 May 2019, 12:24 PM
The reason we have the field_exists() call for when one is upgrading from an older version that field wont exist yet and so breaks site / not allow them to upgrade.
Having said that we should use a more direct test to see if table column exists rather than creating the table / field xml objects and testing via adodb.
As we only use support mysql / postgres we could have a simplified function to do this and hopefully reduce the overhead
From my initial tests there does seem to be an improvement in doing the check directly via a database call in both postgres and mysql
04 May 2019, 12:29 AM
Thank you for your reply,
Good news, i continue my work to try to improve performance.
04 May 2019, 9:42 AM
It would be wonderful if you tested the change that Robert made at https://reviews.mahara.org/#/c/9950/ over the course of the development work and checked from your end if you see improvements.
You can use your Launchpad ID to log into the review system and add yourself as reviewer to be notified when changes are made.
09 May 2019, 12:22 AM
Here the result for 125 users concurrent in 30 minutes (using Jmeter), see the graphs
Before your modification :
After your modification :
There is a major improvement in response time. We should continue our work to identify where the code consume more ressources and returns a long reponse time.
12 May 2019, 11:29 AM
Thank you for the testing and sharing the results, Aurelien.