InterSystems Caché is a multi-model DBMS and application server
During the development of the Terminal Multi-Line Command Editor I discovered in my IRIS installation
a piece of software that I just can classify as a historic artifact. And it is still fully operational !!!
As it dates back to times before InterSystems was founded in 1978 you may understand my surprise.
I personally stepped into that environment in 1978 and used it then for daily work.
Terminal Multi-Line Input with Edit, Insert, Delete, Print extension for IRIS and Caché
IRIS and Caché have just single command lines in terminal available
This Multi-Line Commands Editor also will execute the Multi-line Commands.
In addition, it is independent of access to %SYS and can be installed in any namespace
Special thanks to @Jeffrey Drumm who inspired me to this and supported me as beta-tester.
Running cache 5.0.21 64 bit on Windows server 2016 in virtual environment. Trying to understand why every single process disk read speed (simple sql data walks) caps around ~20MB/s, however 2 paralell such tasks on different data areas can reach 19MB/s each, four - 17MB/s each, that is 70MB/s total, etc. Also simple copy file to nul on that system reach ~400MB/s.
What can keep single query on idle system from reaching for example 200MB/s? Virtualization? Windows? Cache? Processors are below 1-3%
Hi,
Could someone help me in identifying all characters in a column is whole number 0 or greater
CASE WHEN '123' %MATCHES '[0-9]*' then 'VALID' else 'INVALID' end
The above statement is finding only for first character.
Thanks
Hello,
we use a NAS to archive stream from database to files. If we look at the file size on disk, it is bigger than expected.
For example :
File size is 127K
ls -alh | grep write-chupmb-pdf 127K 2020-07-02 10:43 write-chupmb-pdf
Size on disk is 192K
du -sh * | grep write-chupmb-pdf 192K write-chupmb-pdf
Or expected size is 128K (with 4K blocs)
Been cleaning up our production 2017.1 instance of Health Connect in preparation to a move to Health Connect 2020.1 (on IRIS!)
One thing I have found I we have built up a number of old classes and other configuration files.
It would be nice to start on the new server with a clean slate.
Is there any way to identify classes that haven't been used for a long time so they can be reviewed and removed?
Kind regards,
Stephen
