On Fri, 16 Jan 2004 22:03:32 -0800, Brion Vibber brion@pobox.com wrote:
On Jan 16, 2004, at 20:40, Karl Eichwalder wrote:
For the moment, my idea is: the user should be allowed to fetch his list once a day.
What's been hacked in for now is that a fetched watchlist will be cached for an hour, so someone clicking the button over and over won't load things down. The limits can be adjusted here and there if necessary.
I hope it does have a note somewhere telling that. (not that I would use watchlist more often than 2-3 hours).
And switch to PostgreSQL. PostgreSQL obeys the SQL standard much better and thus it is more likely to attract SQL developers
I'd like to assume this statement is backed up with a plan to adapt MediaWiki to work with PostgreSQL and demonstrate superior performance with benchmarks. We're all in favor of choice here and would like MediaWiki to be more generalized, but PostgreSQL advocacy here has a history of being a lot of bluster followed by no action.
Unless someone would like to lend the benefit of their experience in getting the code set up and actually demonstrate something, it's just not going to happen; code doesn't write itself.
Yep. That's the reason I kept my big mouth shut. :) I'm using Psql and tried mySQL a few times, and I was not impressed by its feature set, but mySQL was definitely faster on _read_. The main difference I believe (and it is backed by tests of more potent beings than me) it when a database is being used in heavily loaded read/write mode, due to the better locking features of pgsql. Since I am not familiar with php (to put it nicely the "i hate php" phrase) I cannot tell how complex would it be to change from mysql to pgsql, but as I heard php is pretty general about SQL handling, so it might not be that complex.
Only thing I'm pretty sure in is that it won't be Brion who would do that. He uses mySQL, he KNOWS the beast, I see no reason to force pgSQL down his throat. :) Anyone with php+psql experience could step in and check: maybe it is a trivial change. (afaik mysql's sql syntax is getting close to the standards, so it should be simple).
If anyone want to use my (sort of) psql experience (without php experience) then feel free to ask. I do not have much time to code, though. (another euphemism; I do not have time to code at all.)
Brion, if you can tell me SQL commands which should be timed under psql I can try to convert the en: database to psql and do some tests, like check timing of commands, etc. Naturally I do not have such a huge beast machine like you do, but still, maybe helps.
Peter