How Can I solve the long query time in vmware application?
Posted on 2011-09-02
Im working on my web application in the ubutnto dev -vmware
Im trying to run a query that is working with a large db in one of the scripts I testes the query in phpmyadmin and saw that the time to execute the query in phpmyadmin is around 4.5 second
In the script its running in a while loop around 600 times and its seem like the whole application is stuck while trying to do it (basically it will only have to run once properly and update the db and after it will not be such a large portion)
my question is am I just need to give it a little time to run (not so little around 40 min even though the time in the application will be diffrent than phpmyadmin, but its an estimate)
or the applicationserver is timing it out every time? and the application is stuck