Another way to keep the log database "small":

When I log workflow activity I normally decide how long the log data will be stored. Say I have a limit of 14 days: any log record older than 14 days will be deleted.

Since I use my workflow activity logs for debugging interfaces, I don't need to keep the logged data for longer than that.