Hi Alexander, how does your XQuery/BaseX script look like? If you use the XQuery doc() function, you could try to replace it with parse-xml(fetch:text(...)), because the latter approach will close your documents and free memory if the processed document is not required anymore.
Best, Christian ___________________________ 2013/6/24 Alexander von Bernuth <alexander.von-bern...@student.uni-tuebingen.de>: > Hello all, > > my basex-script should fetch 10.000something XML-files automatically from a > website and insert their content into a external PostgreSQL-database. After > about 8.000 files my script stops and I get "Out of Main Memory". > I found your discussion with "kgfhjjgrn" [1] regarding this issue, but I'm > not sure whether these options apply to my problem - I do not build a > basex-database but an external one. Will autoflush=false and flushing by > myself help with this? > > Second, I want to insert some xs:base64Binary into my PostgreSQL database, > but I cannot find the correct sql:parameter type for the bytea-column. > > Could you please help me with my issues? > > Thank you very much, > Alexander > > > > [1] http://comments.gmane.org/gmane.text.xml.basex.talk/2540 > > > > -- > | Alexander von Bernuth > | alexander.von-bern...@student.uni-tuebingen.de > > > _______________________________________________ > BaseX-Talk mailing list > BaseX-Talk@mailman.uni-konstanz.de > https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk > _______________________________________________ BaseX-Talk mailing list BaseX-Talk@mailman.uni-konstanz.de https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk
