This is the developing spec to look at and make suggestions on: http://docs.moodle.org/dev/Logging_2
Most (all?) of the "realtime" needs that we currently use logging for can in fact be moved in new tables for that purpose, making them very fast. That should free up the long-term logs to be huge and slow if they want to be.