On 1/26/2010 9:46 AM, Kwan Lowe wrote: > On Tue, Jan 26, 2010 at 9:48 AM, Ross Walker<rswwalker at gmail.com> wrote: > >> Some really nice things are happening with postgresql as well, you >> should check it out. >> > > This was a great thread. For one, it's interesting to see the > approaches you can take to solve an issue. I.e., we can tune the OS to > quite a degree, but many times just optimizing a query can lead to > much greater improvements. We can also sometimes throw hardware at the > problem; and sometimes doing that is faster/cheaper than a heuristic > approach :D. Or, if the issue is scaling up the number of reads for web access you might be able to simply add caching in the web app, either locally or with a distributed tool like memcache to offload the work from the DB. -- Les Mikesell lesmikesell at gmail.com