Don't get me wrong, I use databases all the time.  Well, MS Access at least, but I use them for simple stuff like storing items in a shopping list (well not really storing items in a shopping list but you get the idea). It's a little hard for me to visualize in this project.

The thing is deciding what part of the content goes where in the database.

Right now I have a DB that has one table that sort of acts like a TOC of the website and tells where the cached xml is located, when were the files published, etc.  The other table contains all the header/content info for each page, the content which is in the same xml form as the cached xml file. The header isn't in xml form and is in fields (which is then assembled with the content into the cached xml file)


Switching over to classes and OOP actually helped me alot in making the viewing part of the system. I could simply do like:

If objXMLcached.Cached = true Then
xmlCached = objXMLcached.CachedPage
End If

mVPstar