Re: [basex-talk] Out of Main Memory; bytea type

-- | Alexander von Bernuth | alexander.von-bernuth@student.uni-tuebingen.de Am 24.06.2013 um 11:48 schrieb Christian Grün: > 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 >>