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 : [email protected] 
[mailto:[email protected]] De la part de Hondros, 
Constantine (ELS-AMS)
Envoyé : lundi 12 janvier 2015 14:29
À : [email protected]
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.

Reply via email to