Re: [PERFORM] SSD endurance calculations

2011-11-24 Thread Edgardo Portal
On 2011-11-21, Christiaan Willemsen wrote: >We= > are looking at beefing up our servers with SSD's. Some of you did so= > me interesting tests with the Intel 320. So the idea came to make a RAID1= > 0 with four 600GB models. I did however do some calcul= > ations with the current database server

Re: [PERFORM] Slow-ish Query Needs Some Love

2010-02-02 Thread Edgardo Portal
On 2010-02-02, Matt White wrote: > I have a relatively straightforward query that by itself isn't that > slow, but we have to run it up to 40 times on one webpage load, so it > needs to run much faster than it does. Here it is: > > SELECT COUNT(*) FROM users, user_groups > WHERE users.user_group_