Long-running queries: command line or BaseX Gui?
Thursday, 17 February 2022 · 3 messages
JR
Jonathan Robie17 Feb 2022 02:04 #
Do long-running queries run faster from the command line, the GUI, or about the same from either?
Jonathan
BD
Bridger Dyson-Smith17 Feb 2022 02:38 #
Hi Jonathan
Quoted text · Jonathan Robie · 5 lines
On Wed, Feb 16, 2022, 7:04 PM Jonathan Robie <jonathan.robie at gmail.com> wrote: > Do long-running queries run faster from the command line, the GUI, or > about the same from either? >
Without a recent example to pull from, I want to say about the same amount of time (but, obviously, with the preceding caveat).
Quoted text · Jonathan Robie · 2 lines
> Jonathan >
Hopefully that's a help.
Best wishes,
Bridger
Quoted text · Jonathan Robie · 2 lines
> >
CG
Christian Grün17 Feb 2022 11:45 #
The evaluation in the GUI and on command-lines differs in various ways:
• If the command line is used, all results will be returned in an iterative manner, so you’ll immediately get the first results once they are available. As the results need not be cached such as in the GUI, iterative evaluation is often faster.
• If the GUI is used, there is a maximum number of results and a maximum amount of bytes that will be retrieved and returned. This way, the views won’t get stuck if the complete output is huge. You can adjust these limits in the preferences dialog. – Due to these limits, some queries will be faster than on command line, as they might not be fully evaluated.
So, there’s no single answer to that. If you need the full result of a query, using the command line and redirecting the result to a file will usually be the most efficient solution.
Quoted text · Bridger Dyson-Smith · 21 lines
On Thu, Feb 17, 2022 at 1:38 AM Bridger Dyson-Smith <bdysonsmith at gmail.com> wrote: > > Hi Jonathan > > On Wed, Feb 16, 2022, 7:04 PM Jonathan Robie <jonathan.robie at gmail.com> wrote: >> >> Do long-running queries run faster from the command line, the GUI, or about the same from either? > > > Without a recent example to pull from, I want to say about the same amount of time (but, obviously, with the preceding caveat). > > >> >> Jonathan > > Hopefully that's a help. > Best wishes, > Bridger >> >>
Written for BaseX 9.6. BaseX may have changed since: please check the current documentation.
⚡Generated with XQuery