Dear Constantine,

From what I know, optimize only rebuilt indexes and metadata.

Did you try “optimize all” to compact db files ?

But documents’ number should be updated.

How do you get metadata information ?

Best regards,

Fabrice Etanchaud

Questel/Orbit

http://docs.basex.org/wiki/Database_Module#db:optimize

De : basex-talk-bounces@mailman.uni-konstanz.de [mailto:basex-talk-bounces@mailman.uni-konstanz.de] De la part de Hondros, Constantine (ELS-AMS)
Envoyé : lundi 12 janvier 2015 14:29
À : basex-talk@mailman.uni-konstanz.de
Objet : [basex-talk] Pruned, optimized DB shows same document count, db size

Hello all,

I’ve pruned about half the documents of a +-5GB database using XQuery delete. I then optimised the database using db:optimize.

The database metadata still shows the original number of documents, and the overall db filesize remains roughly the same.

I was sort of hoping this pruning would improve performance, but if there’s any difference it’s negligable. Am I missing something obvious?

Thanks in advance,

Constantine Hondros

---

Elsevier B.V. Registered Office: Radarweg 29, 1043 NX Amsterdam, The Netherlands, Registration No. 33156677, Registered in The Netherlands.