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.

On Thu, Feb 17, 2022 at 1:38 AM Bridger Dyson-Smith bdysonsmith@gmail.com wrote:

Hi Jonathan

On Wed, Feb 16, 2022, 7:04 PM Jonathan Robie jonathan.robie@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

...