Is it really the reading file taking so much time or using $piece on the line and setting it to global too?

There are various things here that may slow you, even $increment (best to be replaced by i+1)

You can also split the reading file and set it to global by two parts, and use $sortbegin 

Try to run your code with %SYS.MONLBL started, it will help you understand where it spends more time.

You may slow a bit your process, to leave some process time to other processes.

to do so, you would need to use hang command, somewhere in the loop, with some small value such as 0.1 seconds, and depends how fast is your process may do it once per 100 iterations or more

Look at the query FileSet in %File class

The thing is, that support for Ubuntu appeared later.

It’s actually in process now, to be implemented, should be available soon

Your issue with screen formatting is very interesting, it deserves a separate topic. I have not seen any issues yet with it. While I’d like to find a way to improve a standard IRIS terminal, like irissqlcli, I’d like to see the most challenging parts like this.

webTerminal obviously not a right tool for it. As a replacement for it, you can try to use ttyd, I use it for irissqlcli-web

I wanted to add this ability to irissqlcli, I think it will be useful there. 

Go to Security, Web Applications, select /csp/user, which is default app for the USER namespace, or if you need it for another namespace, find default web application for that namespace. And check Analytics there, and save

You can use whatever you want, just remember about some caveats, like issue with bitslice/bitmap indexes, which requires numerical ID

I would recommend using just a Unique Index for the UUID field and use it, it should cover most of the needs.

I've done a similar task, with much bigger databases. And it was quite good. Mirroring working with data itself, not the on the block level. So, there should not be an issue, if you do not change data stored there.

There are many why's, and this is one of them for sure.

Another few things I found quite interesting

• It starts ECPWork too, even when CE does not have any networking available, including ECP
• It starts up to 7 AUXWD processes, not sure if there is any help from such amount if you have a limit of 10GB of databases there

Yeah, this may happen if Recurse flag is not checked for REST application. IRIS hides this flag for REST, but it is still in use, so, you would need to switch to CSP/ZEN, mark Recurse, and return back to REST

iris.cpf file in the root of IRIS installation, contains these lines

DefaultPort=1972
WebServerPort=52773

If you use version 2022.2 it may not work, try with 2022.3 or 2022.1

The difference in the user owner of the IRIS process, System Management portal is a web process and runing under system user of IRIS irisusr, and your terminal process is under your user.

well, in this case you may use method __setitem__ directly

do ws."__setitem__"("A1", "blah")

Should be quite simple, in some cases even without any configuration. Any ClassMethod has a shortcut to Debug it

Some more settings for different cases, you can find here

VSCode has such feature, from Menu Go -> Go to file, (cmd+P/ctrl+P)

Yeah, that's really, so. Redis has that feature, so you can set a time to live for the value, and it will disappear after that. In IRIS The only way to have something that will be deleted automatically is, Process-Private Globals, but their time to live is tied to the process, and you would still need to clean up if your process is long living.

Any reasons for doing this? This is not how it is supposed to be. REST should answer with Status 401, and optionally  with methods available. And web application when gets 401, it knows that it has to authorize the user, and shows its own page or initiates SSO, depending on the task.

Anyway, if really do this way, It looks like %CSP.REST extends %CSP.Login, and it has Method Login

Called for a REST page in the event of a login being required

Did not test it, but I would expect it will do what requested