MySQL Forums
Forum List  »  MySQL Workbench

Re: Getting the execution time of a query
Posted by: bernard yip
Date: July 11, 2012 06:43AM

Hi Mike,

Thanks foryour insights! They have helped me quite abit! So I should benchmark my queries using the duration.

I would like to know why would it lead to wrong conclusions though? Isn't the results that actually tell you what makes your database perform better or not?

Currently having a headache with dynamically constructed queries, I have no idea how to optimize these kind of queries so I'm trying to play with the settings first. Through setting the settings of my database and seeing if the execution time actually decreases. Am I doing it correctly?

A minor question:
Besides throwing more hardware at the server, setting the database settings, designing the schema and queries, are there any other ways to optimize a database's performance?

Thank you so much for your advice and clearing some of my doubts :)

Thank You
Bernard Yip



Edited 1 time(s). Last edit at 07/11/2012 06:44AM by bernard yip.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Getting the execution time of a query
4616
July 11, 2012 06:43AM


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.