Hi Henning,
db:create("test", "5GB.xml")
You could try to set the ADDCACHE option:
db:create('test', '5GB.xml', (), map { 'addcache': true() })
The CREATE command will probably be faster, because we can ignore some of the XQuery Update semantics on command level.
Hope this helps, Christian
results in a crash. It uses more than 1 GB in memory, I changed the http server memory to 1024MB, and takes more than 20 minutes as the job never finished. Doing the same thing but with basexGUI takes 5 minutes and uses 500 MB memory and finishes.
My question are: what is the difference between basexgui and restxq to give such discrepency, are they not using the same function? Am I maybe creating the database incorrectly? Is there another db:create function I missed?
(Sorry if I sent two mails to Christian Grun)
From: christian.gruen@gmail.com Date: Sun, 22 May 2016 12:32:17 +0200 Subject: Re: [basex-talk] Creating db in restxq interface To: henningphan@hotmail.com CC: basex-talk@mailman.uni-konstanz.de
Hi Henning,
The XQuery Update specification does not allow users to mix updating expressions and return data at the same time. The slides of Arve and Sabine (see [1]) will give you some hints how updates are usually performed in RESTXQ contexts. The slides are from 2013, and some convenience functions have been added since then, but the basic principle is the same as before. In a nutshell:
- Use db:output() to both return data and do updates [2];
- use web:redirect() to redirect to another success page [3];
- alternatively, activate the MIXUPDATES option in web.xml to disable
the XQuery Update restriction [4].
Hope this helps, Christian
[1] http://files.basex.org/publications/xmlprague/2013.html [2] http://docs.basex.org/wiki/Database_Module#db:output [3] http://docs.basex.org/wiki/Web_Module#web:redirect [4] http://docs.basex.org/wiki/XQuery_Update#Returning_Results
declare %rest:path("/start") %updating %output:method("xhtml") %output:omit-xml-declaration("no") %output:doctype-public("-//W3C//DTD XHTML 1.0 Transitional//EN")
%output:doctype-system("http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd") function page:hello() as element(Q{http://www.w3.org/1999/xhtml%7Dhtml) {
<html xmlns="http://www.w3.org/1999/xhtml"> <title>Good day Sir!</title> <link rel="stylesheet" href="static/w3.css"/> <time>The current time is: { current-time() }</time> <body class="w3-container"> <ul class="w3-navbar w3-green"> <li><a href="#">Home</a></li> <li><a href="#">Link 1</a></li> <li><a href="#">Link 2</a></li> <li><a href="#">Link 3</a></li> </ul> <ul>{ for $result in db:open('factbook')//continent/@name return <li>{ data($result) }</li> }</ul> <li> { db:create("test") } </li> </body> </html>
=========== File End ================