This website runs primarily out of a database. The main pages (Catalog, Photo Viewer, Exhibits, and Comments) are all generated using Active Server Pages, Microsoft's cgi application. Of the 24 pages here, only ten of them are regular html pages in the Technical subdirectory. I used Visual Basic Script (VBS) to program the pages. Database Size 3132 KB Public Directories 103  Private Directories 15  Photos 6194  Number of .jpg Files Indexed* 24019  Keywords 3051  Total Image File Size 3756 MB Exhibits 4  Photos in Exhibits 149  Comments 184  Photos Commented Upon 141  Users Registered 11  Photos Viewed 5435760  Total Visitors 6602511  Total clicks 17435217  *Note that the number of .jpg files indexed includes the "b", "m", "s" and "t" versions of a photograph, so it is about 3 times larger than the number of photos in the database. Here is a diagram of the database: The Dirs table contains the list of all photo directories, and what is in them.  The Photo table, the main table in the database, keeps all info about each particular photograph. Most fields in this table are not currently used, but can be if I want to fill them (or when I get a camera that records it automatically). The files table is used to keep file information about each .jpg file, particularly the size. The ratings table stored user comments, and the clients table is used to keep track of privacy, so only those who log in will see their own photos.