Is there a better way to relate a web page to a row in a database?
We currently use a CMS we developed in-house. It's not a full CMS, as it just contains things like the contact name for a given web page, page title, and some other details, but not the content.
As it is now, each page is "linked" to its row in the database by the page URL (minus the doman name). Since this is a text column and not a numeric column, I know it's not ideal, but I can't think of any other way to do it. If I use an ID number, then it seems like I would have to have an ID number on each page (and there are around 60,000 of them) so that would be hard to maintain.
So far, the current method works, BUT our main table is starting to get pretty big, and the server people have asked us to try to reduce the sizes of our databases (we use Access, so each database is an MDB file). I was thinking that it would save space (and improve performance) to somehow make this a numeric field, but I can't think of a way to do it, especially when each page is still its own individual file.
Anyone have any advice?