Re: Slow query (only the first time)
From: Gerard H. Pille <ghp_at_skynet.be>
Date: Sat, 14 May 2011 23:29:28 +0200
Message-ID: <4dcef437$0$14244$ba620e4c_at_news.skynet.be>
"Álvaro G. Vicario" wrote:
>
> As I add additional LEFT JOIN clauses one by one, the execution time increase exponentially.
> Once I manage to successfully run a query that takes, e.g., 10 minutes, successive executions
> run almost instantly! That leads me to think that the bottleneck is the query optimizer
> itself... But, is that even possible?
>
Date: Sat, 14 May 2011 23:29:28 +0200
Message-ID: <4dcef437$0$14244$ba620e4c_at_news.skynet.be>
"Álvaro G. Vicario" wrote:
>
> As I add additional LEFT JOIN clauses one by one, the execution time increase exponentially.
> Once I manage to successfully run a query that takes, e.g., 10 minutes, successive executions
> run almost instantly! That leads me to think that the bottleneck is the query optimizer
> itself... But, is that even possible?
>
You can limit the number of permutations Received on Sat May 14 2011 - 16:29:28 CDT