On Wed, Nov 13, 2002 at 05:46:25PM -0800, Jonathan Walther wrote:
On Thu, Nov 14, 2002 at 12:19:27AM +0100, Tomasz Wegrzanowski wrote:
achieve that goal. Before we have tried Postgres, let's refrain from claiming that it has "obvious" advantages or drawbacks. Otherwise we risk getting entrenched in prestigious preferences, and few things can be more destructive.
What about trying other backends of MySQL ? It has at least two other than the default one - afair BerkeleyDB and InnoDB.
Experience with InnoDB on Kuro5hin.org shows it to be problematic. And it still doesn't give you subselects. Subselects can mean some big savings in terms of query times.
Well, I don't remember Kuro5hin ever having so serious problems as Wikipedia.
I mean - if there are things that we can check out just now, with very little work, then let's do it. In the worst case, if they won't improve anything or even be worse than current MySQL, we will just be where we started with little efford wasted.