I noticed that there is no parsed post table. Does this mean that the bbcode is parsed in each and every time that the post is rendered?
While such a cache does need to be updated following changes to BB codes, that process doesn't normally involve the 'entire database.' For example, vB's post caching system only caches recent posts.As long as the code is efficient that parses the bbcode I actually see this as an advantage. If you have to modify the results of a bbcode you don't have to have it reparse the entire database everytime you make a change.