Adding a CI in a change ticket is very long

[Franck]

Hello,

I have a slowness problem when my users try to add a CI within a change.

The mod op: new change then CI tab and we click the plus button (see attached image)

Users must then wait 2min30/2min50 to have the CIs displayed (see waiting message attached)

With a mysql expert, we saw that by optimizing the initial query and creating an index we go under the second bar.

We checked in our custom extensions and no trace of this query (attached)

My question: Where could the query of this plus (+) button be hidden? :)

[Jeffrey Bostoen]

It would be built dynamically.

What index did you add to improve the situation?

[Franck]

Hello,

Thanks for your feedback.

To answer your question, we added an index in this way:
create index src_fci_name on functionalci(name,id) ;

And in the query we change => ORDER BY FunctionalCI.name ASC

But, we have done tests in 'SQL query'. We have not yet implemented the solution since we do not know where to modify the query in the code.

You indicate that the query would be built dynamically, but do you know where the code that builds the query which is behind the (+) button ?

Thanks,
Franck