On 1/26/2010 9:46 AM, Kwan Lowe wrote:
On Tue, Jan 26, 2010 at 9:48 AM, Ross Walkerrswwalker@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.