Database Performance

Wed Mar 11, 2015 1:14 am

I have run a loading test on the database request from Singapore location by using www.loadimpact.com. Please refer to the result figure

http://goo.gl/mGdI5l

The average load time across the whole test is 2.1s which is a little bit slow. Also, there is a out-of-expect load time, 6.23s, at 1:31:20. I have the following questions:

Any idea why there is a very long load time sometimes?
Is there any plan to improve the database access performance?
Do you have any testing result when the number of concurrent users in higher level ( 500+ users )?

Thu Mar 12, 2015 7:19 am

Hello Peter,

Unfortunately we are not familiar with http://www.loadimpact.com/, we use other services for testing our db and average load time is 500ms. And to explain the results of this test we need to know what queries were sent, how much data was in the database, etc. This service could sent "heavy" queries, or for example a lot of data was generated and the fields' indexes weren't made, which were used for the filtering.