On Tue, 6 Jul 2004, Chris Smith wrote:
> Thanks for your reply. Here is the output of "explain analyze". I also
> replaced by simple values with a real query that gets run and (according to
> our profiling) takes a long time. However, the query is now taking a much
> shorter period of time tha
Stephan,
Thanks for your reply. Here is the output of "explain analyze". I also
replaced by simple values with a real query that gets run and (according to
our profiling) takes a long time. However, the query is now taking a much
shorter period of time than it was profiled at by the application
On Fri, 2 Jul 2004, Chris Smith wrote:
> I've just noticed in the regular profiling information from our web
> application that a particular query on a fairly small database is taking about
> 15 seconds. The query is generated from software on the fly, hence its
> quirkiness -- if any of that is
