Re: [PERFORM] Strange result: UNIX vs. TCP/IP sockets

2003-07-08 Thread Andrew Sullivan
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

Re: [PERFORM] Efficiency of timestamps

2003-07-08 Thread Stephan Szabo
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

Re: [PERFORM] Efficiency of timestamps

2003-07-08 Thread Stephan Szabo
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