• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

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

#1
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

XenForo developer
Staff member
#2
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.