XF 1.5 Maximum execution time of 120 seconds exceeded - library\Zend\Db\Statement\Mysqli.php:70

[Zesix]

Is there a way to optimize this?

I'm running ClearDB as my database and I get this error whereas previously I did not have this problem on a shared host. I know ClearDB does put limits on SELECT queries, so if there is a way to optimize the prepare statement on line 70, let me know.

 

[Chris D]

Unless there's an add-on involved, there should never be a situation where XF takes over 2 minutes to run a query. It's certainly not going to be the query that needs to be optimised. You are going to likely need to be looking at optimising the server/db platform itself. For this, you should contact your provider.