We integrate MantisBT 2.18 with other tools. These tools use the SOAP API with 'mc_project_get_issues' method and the following parameters:
Code: Select all
<man:mc_project_get_issues soapenv:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
<username xsi:type="xsd:string">XXXX</username>
<password xsi:type="xsd:string">XXXX</password>
<project_id xsi:type="xsd:integer">394</project_id>
<page_number xsi:type="xsd:integer">1</page_number>
<per_page xsi:type="xsd:integer">200</per_page>
</man:mc_project_get_issues>
To detect where the loss of time might occur, we used an Application Performance Monitoring tool. We identified that several requests was done and take a few milliseconds each. So the response time is due to the amount of requests or the data processing.
We think the response time is related to the number of notes, attachments of each issues, but we can't check.
Is the problem known ? What are the possible reasons ?
Is there a way to decrease the response time of this method by tuning in configuration files ? or in the server configuration ?
For information the database sizing is about :
- mantis_bug_file_table (18K lines) 3.8 Gib
- mantis_bug_history_table (310K lines) 24 Mib
- mantis_bug_revision_table (20K lines) 7.6 Mib
- mantis_bug_table (20K lines) 3.4 Mib