Hi Team,
I have a XML DB with approx 8 GB in size. The size of the DB will go on increasing through monthly updates. The size of monthly update will be around 10 MB in size.As the DB is storing text documents, I will have to index the full-text index again, after updating to speed up the process. Sometimes, I get Heap Space error too !!
My DB will be stored at the user end. Then how come I will be able to Optimize it?
Also the DB is created using a huge XML file.
After viewing the Statistics (http://docs.basex.org/wiki/Statistics), I came to understand that the size of my DB is stands no where, when compared to at least, first 15-16 entries !!.
This situation has always troubled me a lot. May be I am doing it in wrong way.. Can you guys put light on this?