I don’t know what Jim’s actually got going on in the guts. Whatever it is, has to ensure that writes are atomic, that nobody gets just part of a posting.
I don’t think he’s using a commercial database e.g. Oracle. That would be vastly too expensive to license, judging by the budgets we’re seeing.
If some well to do Freeper wills a million bucks to FR things would probably drastically change. At least a piece of serious hardware could be had.
Yeah, I think that's the problem. If they are using MySQL, it is known to have a performance constraint, although they may have addressed it in later released.
I don’t think he’s using a commercial database e.g. Oracle. That would be vastly too expensive to license, judging by the budgets we’re seeing.
While Oracle would be a great performer and scale well to a cluster, it's not a reasonable solution. The Freepathon budgets would have to double, at least.
Postgres is free, and is used for a lot of serious database implementations. Historically, it has been a better performer for large datasets. I don't know if that is still true in the latest versions. Both also support clustering, although it's a bit more hassle on Postgres.