I have been trying to lookup information regarding the view indexes and I guess Im not understanding very well.I have a database that is 360 MB after running compact -d and discarding any view indexes. I can immediately open it and do CTL & SHT & F9 to recreate them. The db size increases to 520 MB right away. Is that normal? Why would the view indexes be that large? I know # of views/folders etc. But it still seems abnormally large. Can anyone point me in a good direction to investigate?
Subject: View Index Size - Normal?
The key stroke recreates ALL indexes, then in the nightly tasks any indexes that are not used regularly are deleted once they expire, i.e. not used at all over a certain time period.
That accounts for the different sizes.
Open a view in design mode, in the properties box flick through the tabs and one of them contains this settings.
Subject: Please supply more information…
It’s not unusual for view indexes to take up a lot of the actual database space. Sortable columns can cause this, as each sort has it’s own index.
Subject: RE: Please supply more information…
its own index
Subject: Please supply more information…
Could you post some more information about your database.
How many view/folders are there?
How many columns?
Are the columns sortable?
How many documents are in the database?
All these things affect the size of the database when updating view indexes.
/Hans Fokine
Subject: View Index Size - Normal?
There is no “normal”. In a database where there aren’t that many documents and the size of the documents is mostly rich text and attachments and there are only a couple of unsorted views, I might not expect the 50% growth you are seeing. In a database with many document, few atttachments, and lots of views with lots of sorted columns, growth of 100%, 200%, 300% or more is certainly possible.
Subject: RE: View Index Size - Normal?
Couldn’t have said it any better. And usually the plain total size of view indices should be one of the least things to worry about, as long as overall server and application performance is still OK.
If not, there might be room for optimization. André’s brand sparkling new white paper on performance basics
and the (not so new) resources he points to would be a good start then.
Of course, it would be nice, if we could keep view indices on a separate disk. At least, there are 45 people who think so …
http://ideajam.net/IdeaJam/P/ij.nsf/0/A4203DB41738FBF4862573B10029E8F4?OpenDocument