Hi All
I’ve got a very old database that’s been worked on by various people over the years.
What we have ended up with is a very bloated database with a huge number of views. Is there are simple way of finding out which views are still in use?
I need to be wary of views that are used within other elements like forms.
Any suggestions will be greatly appreciated
TC
Subject: Removing dead views
Its not great, but you can do a design synopsis (make sure you include everything), and just do a text search for the name of the view. If it’s mentioned in any code you’ll know not to delete it.
Dan
Subject: Removing dead views
log.nsf Database Usage by Size. Look at the document that represents your database. Look at the views that are 0kb. Those represent views that haven’t been used for a long time, exactly how long depends on settings in your view properties, but the point is that this is a good place to start. Regardless of whether you’ve got code that points at a view, if that code has not been accessed in months then it’s a candidate for being pushed out.
What I do is start this way and take a few at a time and delete them after first copying them locally somewhere so I can bring them back quickly. I do this every few months until I’ve trimmed the db down a reasonable amount. It’s hard work because the more you trim the closer you come to actual functionality and ruining someone’s day.
regards,
raphael
Subject: Removing dead views
Something I did a number of years ago when I had to figure out who was using which views and why in an effort to get the views under control. On the view queryOpen event I put some code that sent an email to a mail enabled DB. The mail doc contained the view name, user name, the date and time that the user opened it then in the target DB I created a couple different views. Just because a view does not appear to have been accessed however, does not mean that it is not used. If a view is accessed by an agent to do a look up etc it will not show up because the View QueryOpen is a UI method. But it sure helped track dow who was using what. I was able to delete a bunch of views, plus by making a few changes to existing views I was able to consolidate several views into one.Today with single category views and some of the new features I’m pretty sure that I could do even a better job of paring them down.
Subject: RE: Removing dead views
There is an example from Doug Finner in the Notes r5 forum,
JYR
Subject: Removing dead views
Not very sure but u can open database in designer & check the view properties for “Accessed”
This shows the last time view was assessed in the file
Subject: RE: Removing dead views
look in the R5 forum, there is an excellent post from Doug Finner about View usage
JYR
For faster answers, be C R I S P Y