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-bernuth@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-bernuth@student.uni-tuebingen.de
BaseX-Talk mailing list BaseX-Talk@mailman.uni-konstanz.de https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk