I have started to take a look at the database structure. I think eventually I'll be able to come up with some ideas for speeding things up. So far I've just been playing with the data.
The following SQL statements search the Recent Changes tables. Unfortunately, without subqueries it gets cumbersome.
-- Changes by multiple users select rc_user_text, rc_title, rc_comment from recentchanges where rc_user in (4369, 188, 2376) order by rc_timestamp desc limit 999
-- Changes by sysops select rc_user_text, rc_title, rc_comment from recentchanges where rc_user in (100, 1078, 1104, 1123, 1131, 1132, 1300, 150, 166, 17, 188, 2, 24, 29, 30, 300, 31, 3113, 3362, 34, 369, 38, 39, 4, 43, 488, 51, 513, 584, 59, 62, 66, 68, 733, 83, 86, 90, 94, 95, 97, 99) order by rc_timestamp limit 999
Other SQL statements:
-- blocked IP's sorted by blocker select user_name, ipb_address, ipb_reason, ipb_timestamp from ipblocks, user where ipb_by = user_id order by user_name, ipb_timestamp
-- Anonymous edits select cur_user_text, cur_title, cur_comment from cur where cur_user=0 order by cur_timestamp desc limit 99
-- Vandal track select rc_user_text, rc_title, rc_comment from recentchanges where rc_user_text = '213.229.14.90' order by rc_timestamp desc
Ed Poor