Hi All
One of our databases has gotten too large and as archiving is not an option at the momenet, we are planning to remove the attachments and pasted images.
I know that a view can display name & length of attachments in a document. Is it possible for a view to display if the document has a pasted image and optionally size of the image?
Thanks in advance
Alpna
Subject: Display in view - if any pasted image in a document
The best you can do in a view is show the size of the whole document and whether there are attachments. With those two piece of information, you should be able to catch a fair number of the pasted in images.
Subject: RE: Display in view - if any pasted image in a document
Thanks for your response Ben. This will be useful.
Though the strange thing is that the database size is 2 GB but if I add the size of all (20000) documents in the database is only 811 MB. Not sure what is using rest - some would be used by design documents - but not 1200 MB. Wonder if there is a tool to figure out the database stats.
Regards
Alpna
Subject: RE: Display in view - if any pasted image in a document
Not sure if this helps but I use to work where there was a DB that added apx 100,000 docs a month to the DB, so the sized added up quickly and performance became a problem. I was asked to look at the DB to try to improve performance. We found out that the DB itself was 1 GB, we made a local copy, but when the all of the views were built the DB size increased to 8 GB.
Guess what I am getting at is that the size of the DB can be greatly increased by the views, after the indexes have been built.
Subject: View Indexes
Yes, it seems like view indexes - I deleted a few views and the database size reduced by 200 MB. I will try to get rid of some more views and see if the database size becomes less.
Where can I find information about view indexes and how to manage database size.
Thanks
regards
Alpna
Subject: *Sounds like view indexes. May be too much summary info, or too many views