Made some tweaks to the profiling; it can now be set to log only profiling data (without other debug junk), and to log it only when the total time spent > X seconds.
Currently logging to /apache/profile/en.profile on larousse. The first bit will be without any limit; then with 1.0 second limit, then with the title-parsing code filtered out (always fairly fast, but a lot of them, it ends up being useless noise), then with a 5.0 second limit.
I noticed also that the user_newtalk table didn't have any index on it, which may explain why a lot of newtalk check queries were fairly slow. I added indexes, but they're still sometimes oddly slow.
alter table user_newtalk add key(user_id), add key(user_ip);
Will try to process the data some in a bit...
-- brion vibber (brino @ pobox.com)