Observing Blogs on mine, and especially on the arrse site, the user profile block really slows it down - the initial query is very slow. I don't really see the value in having that block present, so I'll add an option to disable it.
This version will also add a genuine user id column to the tables to eliminate this nonsense of having to match the username against the users table to obtain the user id.
With the subsequent changes to utilize a genuine id, this will affect some blogs where the blog username (aid) does not match the users username. I guess I could add a special link to generate a listing of such usernames so that people can correct them?
Was easier than I thought - that's a worry
Pre-release here
This does modify the database tables for blogs and comments and generates the uid in each case by looking up the users table. Also adds the option to turn off the profile members block. There is also a link in the config section to find missing user IDs after the install.
Back-up tables and files.