On 7/6/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
How does the cpu power influence the speed of a query?
Sort is a cpu intensive process. *Check if you are suffering from locks on the tables you look up.* Also, was the table in the system where the queries are running faster rebuilt recently. You can try rebuilding the tables. How is the overrall system load on both machines. Is one overloaded than the other ? The machine which takes longer to excute the query might be busy serving some other process other than MySQL. Thanks Alex
