Jump to content

SQL Taking Too Long - Resulting in server going down


Recommended Posts

Hi Members,

Below script is taking too long to execute because of which hosting server is going down. Nothing major has changed on the website, except addition of some new products which also seems to be correctly added. I have disabled those products and checked, but issue still persist. Script is taking time even when executed from MySQL. 

image.thumb.png.96503d466cb8d12d9db7af50c96c72f7.png

Please suggest.

Thank you everyone in advance.

Edited by Ganesh Bane
Script added as image. (see edit history)
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...