Thank you very much the example code was excellent and I was sort of able to solve the problem.
Maybe its okay to continue here though the problem statement has changed.
In restxq, creating a database locally with 'db:create("test", "5GB.xml")' 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}html)
> > {
> > <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 ================
> 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}html)
> > {
> > <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 ================