Constantine, Did you mean db :delete or delete nodes ?
I'm using 8.0 769b53b and after db:delete, even without optimize, I get correct documents' count in the GUI window. Best, Fabrice De : [email protected] [mailto:[email protected]] De la part de Hondros, Constantine (ELS-AMS) Envoyé : lundi 12 janvier 2015 16:32 À : [email protected] Objet : Re: [basex-talk] Pruned, optimized DB shows same document count, db size Aha, of course, the all boolean. I did not try that, and will. DB metadata I get via the GUI menu : Database -> Open and Manage Cheers, C. From: Fabrice Etanchaud [mailto:[email protected]] Sent: 12 January 2015 16:14 To: Hondros, Constantine (ELS-AMS); [email protected]<mailto:[email protected]> Subject: RE: Pruned, optimized DB shows same document count, db size 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]> [mailto:[email protected]] De la part de Hondros, Constantine (ELS-AMS) Envoyé : lundi 12 janvier 2015 14:29 À : [email protected]<mailto:[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. ________________________________ Elsevier B.V. Registered Office: Radarweg 29, 1043 NX Amsterdam, The Netherlands, Registration No. 33156677, Registered in The Netherlands.
