Slowly for show to dos

[rslemer]

I did create a  association for service contracts and To dos


But when I  access tab more information, system is very slow to list to dos, even when service contracts has only 1 to do

About 15s to 30s and more to show ...

How I can improve this performance

[joebordes]

get the query using DEBUG_RELATEDLIST_QUERY global variable and then pass it through mysql with an "EXPLAIN" and share your results