MySQL Forums
Forum List  »  Performance

Advanced Search
New Topic

Re: Reduce the Query Execution Time Between MYSQL & VC++
Posted by: Rick James
Date: November 14, 2014 07:55PM

The settings look fine.
If this is the query
SELECT PNAME FROM PROFILEMASTER
and that table has only 27 rows, it is not MySQL that is taking 5 seconds.

27 _million_ rows might take 5 seconds, but not 27 rows.

Can you print out times at strategic spots in the code? Can you comment out the MySQL code to see what the rest is taking? Etc.

Navigate: Previous Message• Next Message
Options: Reply• Quote




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.