Erik Moeller wrote:
(Is there any way to determine if the index is used,
BTW? MySQL has
some weird conditions under which it ignores indexes.)
Stick "EXPLAIN " in front of a query; it comes back and tells you if
it's using indexes, how many rows it turns up, yada yada.
I noticed that there is already a
recentchanges table that new rows are inserted into upon edits. Is a
move away from SELECTs on the CUR table already in the works? If so,
what is its current status and who's doing it?
I had been under the impression we were already using that table, but,
well, we're not! I dashed off a quick change to use it (so a single
query to the recentchanges table instead of two separate ones to cur and
old), it seems workable. Committed to CVS, not yet installed on the live
server.
Unlike the current code, initial page creation events are still marked
as new even when there's a later revision. Yay!
Caveat; various things are _not_ currently registered in the
recentchanges table:
* Updates to deletion, upload logs
* Creation of image description pages on file upload
* Deleted pages remain listed as though they existed
Those should be fixed. Any other problems?
-- brion vibber (brion @
pobox.com)