This is blocking for Oracle users, but unwise for the other DBMS anyway:
When using the traceability matrixes,
And when the global limit is more than 20k, so the default pagination is more than 1000 lines,
Then by default, the screen can't display the matrix.
Technical explanation
ActiveObjects retrieves all properties in separate queries, so 1 search containing 1000 results did 4001 SQL queries (1 + 1 per requirement for properties + 1 per requirement for links + 1 per requirement for dependencies + ...). So we've improved and there is only 1 lookup for the 1000 properties together. Except, Oracle doesn't allow 1 request with 1000 parameters.
Resolution
We'll send requests by groups of 900 max. So pages with 10k requirements (!) will be done in 12 requests instead of 1, which is wiser.
This is blocking for Oracle users, but unwise for the other DBMS anyway:
When using the traceability matrixes,
And when the global limit is more than 20k, so the default pagination is more than 1000 lines,
Then by default, the screen can't display the matrix.
Technical explanation
ActiveObjects retrieves all properties in separate queries, so 1 search containing 1000 results did 4001 SQL queries (1 + 1 per requirement for properties + 1 per requirement for links + 1 per requirement for dependencies + ...). So we've improved and there is only 1 lookup for the 1000 properties together. Except, Oracle doesn't allow 1 request with 1000 parameters.
Resolution
We'll send requests by groups of 900 max. So pages with 10k requirements (!) will be done in 12 requests instead of 1, which is wiser.