One of the things that can contribute to excessive database file size is the size of the view indexes in the database. You can easily check to see how big all the views are by running the following command at the server console:
show database dbname.nsf
If you have any huge view indexes in the database, you might want to trim them down by reducing the number of sorted columns or by filtering the docs in the selection formula.
Like this:
Like Loading...
Related
Published by CyberDude
I am a CyberSecurity specialist, solutions architect, blogger, twitterer working for a state of the art and innovative technology company. My main responsibilities are to help enterprises protect their data and systems of engagement from unlawful breaches into their network and endpoints. Okay, that was a bit over the top, so to net this out, just think of a cyber cop protecting your perimeter and securing your entryways into your systems.
Much of my spare time is spent trying to get a balanced life. Taking the time away from work and just enjoy life. Keeping my mind and body fit by running Spartan Races. Spending time with family and friends. Eating a balance diet..yada yada yada...and living the dream.
View all posts by CyberDude
