Opening backend sermons page take more than 3 minutes

Hi,
We just upgraded from Joomla 3 to Joomla 6 as suggested in a previous post.
We have about 20,000 sermon entries
Now, Opening the backend sermons page take about 3.5 minutes, running 145 queries
Attached an image of the profile tab of joomla
 

Also attached the most notable queries taking more than 100ms
 
 

PHP version 8.3.33
MySQL 8.0.46-cll-lve
Joomla 6.1.3

 

20'000 sermons is certainly more than I have in my testing setup 
3,5 minutes still is way to slow. I'm happy to check what could be the cause. The SQL queries you posted may be part of the issue, the "group by" there likely will be slow. I'll have to check why it's even there. It may only be needed if you filter by a scripture book, so I could make it at least conditional.

I would be interested in a SQL dump of your sermonspeaker tables, so I could test it in my testing enviroment. Can I ask you to send me the tables to my email (bakual@bakual.ch)? That would be helpful. I could then also check if I need to add some indexes to the database tables to improve the queries.
If not, I will have to generate some thousands of entry manually to test this. But it's always better to have reallive data.

Sent you the data by email.
Thanks!