Hi all,
You may remember in my last report, I said that it appeared that
TCP/IP connections caused EXPLAIN ANALYSE to return (repeatably but
not consistently) slower times than when connected over UNIX domain
sockets.
This turns out to be false. We (well, Chris Browne, actually) ran
some tests
On Tue, 8 Jul 2003, Martin Foster wrote:
As I keep looking through code to see where I can make things more
efficient, I noticed that in some cases timestamps seem horribly
inefficient. This leads to very long run times for certain queries.
Here is an example:
-- USING TIMESTAMPS TO
On Tue, 8 Jul 2003, Martin Foster wrote:
Stephan Szabo wrote:
I think you might get better results with some kind of multi-column index.
It's using the index to avoid a sort it looks like, but it's not helping
to find the conditions. I can't remember the correct ordering, but maybe