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.