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.