Re: Query works in my localhost, but not on my web page
Best clue is that ir's long. Lots of posts here on 5.5-5.6 performance losses--you'll find several useful tips.
Or post the query text along with the result of Explain Extended on the query, along with Show Create Table results for each table in the query.
If that seems too much, I would start by commenting out bits of the query till it runs, see what Explain Extended thinks of the diff, and try to optimise those bits.
Subject
Written By
Posted
September 12, 2015 08:57AM
Re: Query works in my localhost, but not on my web page
September 12, 2015 11:33AM
September 12, 2015 12:17PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.