Query Takes approx 82 seconds in Workbench and 3 minute 30 seconds in program
I'm using connector/net to run a query that basically counts the number of records and groups them by month. On MySQL Workbench it takes between 80 and 90 seconds to execute. I copy pasted the script/query from Workbench onto my MySQLCommand in my code and then used ExecuteReader to run it. The output is just 7 rows with two columns, but it's taking around 3 minutes and 15 seconds to execute when I run it from my program. That's 195 seconds. Why?!?! :)
I'm updated to 6.9.3. I've already spent a couple of hours searching Google for answers. I'd appreciate any input on why the drastic difference in execution time.
Subject
Written By
Posted
Query Takes approx 82 seconds in Workbench and 3 minute 30 seconds in program
September 17, 2014 05:30PM
September 29, 2014 02:00PM
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.