[PERFORM] Help me understand why my subselect is an order of magnitude faster than my nested joins

Hello, I have two versions of essentially the same query; one using nested joins, the other using subselects. The version using the subselect is roughly an order of magnitude faster (~70ms on my box and data vs ~900ms for the nested joins). Of course the obvious answer here is just to use the fast

Re: [PERFORM] Optimal settings for RAID controller - optimized for writes

On Sun, Feb 16, 2014 at 11:49 AM, Niels Kristian Schjødt wrote: > > Hi, > > I'm kind of a noob when it comes to setting up RAID controllers and tweaking > them so I need some advice here. > > I'm just about to setup my newly rented DELL R720 12. gen server. It's > running a single Intel Xeon E5-