Hi,
I want to implement pagination through Basex.
results should be retrieved as per given range / size.
and I don't want to modify XQuery.
is there any way to achieve this requirement ?
-
Kunal Chauhan
Hi Kunal,
Did you see my post about paged results?
Wouldn't that work for you?
I don't understand your remark about don't want to modify XQuery?
How else would you want to achieve it?
Paul
Hi,
I want to implement pagination through Basex.
results should be retrieved as per given range / size.
Some time ago, Charles Foster had the idea that all bound variables
should be added to the stack trace whenever an error occurs [1]; would
that be helpful? Before implementing this, however, we would need to
think of various issues related to performance (try/catch statements
will get slower when
If that means that I may get thousands of XML files in the trace when batch
processing, it seems I would get so much information that what ever is
relevant would get lost in the mess. It may be useful for other use cases.
I'll let other people debate their case about adding that much info to the
I am using BaseX restxq for accessing a repository from a web browser.
Uploading files works smoothly, but I can't see how to make a download
button work.
For uploading, the recipie on the restxq help page was enough to get it to
work. Is there a corresponding way for making downloading work?
What
Hello,
I have a 1GB sized xml file.
which contains 94,50,001 records.
while I fired query to retrieve all the records it will take approx 30 secs
to execute a query.
*I fired below mentioned query using Java API (QueryProcessor). *
transaction/* except (/transaction/traInfo)
If that means that I may get thousands of XML files in the trace when batch
processing, it seems I would get so much information that what ever is
relevant would get lost in the mess.
It would mean that all variables would be bound to a map in an
additional error variable (e.g.
Hi Kunal,
we need more information to help you here. How does your query look
like? Does it benefit from index structures (please check out the
output in the QueryInfo panel)? Are your index structures up-to-date?
while I fired query to retrieve all the records it will take approx 30 secs
to
Hi Lars,
You need to return a sequence of two items: (restxq:response,thedata)
I do something like...
declare
%rest:path(/download/{$file})
function page:download-file($file)
{
(download-response(raw,$file), file:read-binary(..))
};
(:~ headers for download :)
declare function
Hi Christian,
how to print QueryInfo through Java API ?
I checked query in BaseX GUI and over there it shows Total time : 21 secs.
What else do I need to check in QueryInfo panel ?
apart from this following is my DB info.
*Indexes*
Up-to-date: true
TEXTINDEX: true
ATTRINDEX: true
FTINDEX:
Thanks a lot Andy! It works like a charm. Now the filename can be
manipulated as well. Perfect!
Best,
Lars
2014-08-21 17:10 GMT+02:00 Andy Bunce bunce.a...@gmail.com:
Hi Lars,
You need to return a sequence of two items: (restxq:response,thedata)
I do something like...
declare
how to print QueryInfo through Java API ?
The -V flag or the QUERYINFO option are alternatives; please find more
information in the documentation.
transaction/* except (/transaction/traInfo)
You could try to rewrite this to...
transaction/* except traInfo
...or...
let $traInfo :=
transaction/* except traInfo
Sorry, this one was nonsense.
Hi Chris,
Yes, that seems to make it work correctly. Maybe the wiki needs to be
updated to be more clear about what diacritics true does?
I have slightly updated the text entries in our Wiki [1]. You are
invited to register for the Wiki and update the text if you believe it
could be further
14 matches
Mail list logo