Re: Getting the execution time of a query

[bernard yip]

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.