Mantis Bugtracker 

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0008761TestLinkReq Overviewpublic2019-09-11 13:132019-09-11 14:47
Assigned To 
PlatformOSOS Version
Product Version1.9.19.01 (1.9.19 fixes) 
Fixed in Version 
Summary0008761: Latencies when loading the page "Requirement Overview"
DescriptionIn some use cases, processing time goes to more than one minute. There are two different reasons why we can notice latencies when loading the page “Requirement Overview”:

Back-end reason (server side):
This latency happens when Custom Fields are present in a requirement. After having analyzed the implementation of this functionality, I found that two additional SQL queries are made for each requirement when requirements have Custom Fields related. The first one requests the project ID (that is useless) and the second one requests the Custom Fields value of the requirement (that can be optimized). I already have a good idea of how reduce this processing time, we could discuss it.

Front-end reason (client side):
Firefox seems not efficient with the use of Ext-JS (old version) and with more than about 2000 requirements. I have no real solution for this use case except upgrade or remove Ext-JS.
Steps To Reproduce- Having 1000 to 5000 requirements
- Add custom fields related to requirement
- Try load the page "Requirement Overview"
Additional InformationI made tests with 5000 requirements without any relation or other information. For each requirement, I added progressively relations with test cases (3/req) then relations with requirements (3/req) and finally custom fields (3/req).
TagsNo tags attached.
Database (MySQL,Postgres,etc)MySQL
BrowserFirefox 68 / Chrome 75
PHP VersionPHP 7.2
QA Team - Task Workflow Status
Attached Filespng file icon chrome.PNG [^] (21,240 bytes) 2019-09-11 13:13

png file icon firefox.PNG [^] (23,861 bytes) 2019-09-11 13:13

- Relationships

-  Notes
fman (administrator)
2019-09-11 14:47

It would be great if the right pointer to the code is provided, in order to make things simpler.
When you said that something can be optimized is also important to have your findings, to avoid doing the same work twice.

The simple structure used to manage the tree on DB is know to create issues due to two the recursive nature.

- Issue History
Date Modified Username Field Change
2019-09-11 13:13 c2pil New Issue
2019-09-11 13:13 c2pil File Added: chrome.PNG
2019-09-11 13:13 c2pil File Added: firefox.PNG
2019-09-11 14:47 fman Note Added: 0029151

Copyright © 2000 - 2019 MantisBT Team
Powered by Mantis Bugtracker