> On Mon, Feb 03, 2003 at 05:51:23AM -0800, Jimmy Wales wrote:
>> It strikes me that some of our nice "extra" features, like Most
>> Wanted, are slow and could also be just as useful (or nearly so) if
>> they were not generated 'realtime', but rather if they were generated
>> only once per day.
> There's really still a lot we can do in terms of database optimization. I
> have just installed Wikipedia at home again, and still have access with my
> Sourceforge account (I think), so if Brion wants me to I could actually
> start making my hands dirty again. :-) But when messing with the database
> good coordination is extra important, so it should be very clear who is
> working on what.
If you have a good connection, I suggest you import both the CUR and OLD
tables of the English Wikipedia. Some of the queries are dog slow even
when locally run.
http://www.wikipedia.org/wiki/Wikipedia%3ADatabase_download Regarding coordination, you mostly need to check with Brion. Us others
primarily work on creating new problems ;-)
Thanks for helping out,
Erik