I'm testing the scripts on GUI, I don't really use command line. I also run them on a basexhttp instance. I will check it out, however I like to keep the scripts as close to the xquery spec as possible.
No problem! I am just asking because large results in the query will first be cached before they are displayed in the GUI. On command-line, single items will be iteratively output as soon as possible. As a consequence, outputting zour 900,000 rows shouldn’t cause additional overhead on command-line, but it will increase memory consumption in the GUI.
Hope this helps, C.