Re: [PERFORM] Scaling further up

2004-03-02 Thread johnnnnnn
On Tue, Mar 02, 2004 at 02:16:24PM -0700, scott.marlowe wrote: > It's a common misconception that faster RPM drives are a lot faster, > when, in fact, their only speed advantage is slight faster seeks. > The areal density of faster spinning hard drives tends to be > somewhat less than the slower sp

Re: [PERFORM] sql performance and cache

2003-10-13 Thread johnnnnnn
On Sat, Oct 11, 2003 at 10:43:04AM +0100, Chris Faulkner wrote: > I have two very similar queries which I need to execute. They both > have exactly the same from / where conditions. When I execute the > first, it takes about 16 seconds. The second is executed almost > immediately after, it takes 13

Re: [PERFORM] One or more processor ?

2003-10-10 Thread johnnnnnn
On Fri, Oct 10, 2003 at 12:42:04PM -0400, Bill Moran wrote: > 4) It simply isn't practical to expect a single query to >execute on multiple processors simultaneously. > > Do you know of any RDBMS that actually will execute a single query > on multiple processors? Yes, DB2 will do this if conf