go to post Robert Cemper · Jun 26, 2021 20/30 tables and 300 columns is quite a heavy query / view.VIEW is only a stored SELECT. The same considerations apply. #1)you should have an index for each column that appears in a JOIN ON.. on WHERE...and that's hopefully just 1 index by table#2) for each table the required columns should go as Data into the indexYou are perfect if the query analyzer only shows access to indices. My proposal only covered views of a single table with indices Materializing a multi-table view as you describe it would require a hidden table with all JOINsand no filtering WHERE clause. And you would require extra code to keep it up to date.This is a job that the query generator does in an excellent way and with all tricks available.I wouldn't say it's impossible. And the final query is definitely faster. But it may take weeks or months to get it running. Not to talk about maintenance.Analytics/DeepSee acts in a similar way. And I can prove: it wasn't done in an afternoon session.
go to post Robert Cemper · Jun 23, 2021 It is not very fresh but might be useful anyhow Sharding evaluation #1 + Sharding evaluation #2
go to post Robert Cemper · Jun 21, 2021 check here https://docs.intersystems.com/iris20211/csp/docbook/DocBook.UI.Page.cls?KEY=ASAMPLES
go to post Robert Cemper · Jun 19, 2021 Thanks for raising the issue.I experience the same behavior with a fresh Docker Image
go to post Robert Cemper · Jun 17, 2021 The SQL statement should look slightly different Insert Into TableX (Name, Address, Phone) SELECT 'Name1', 'Address1', 'Phone1' UNION SELECT 'Name2', 'Address2', 'Phone2' UNION SELECT 'Name3', 'Address3', 'Phone3'
go to post Robert Cemper · Jun 17, 2021 the base class for all Webpages (also REST) from IRIS is %CSP.Page.clsWhen a csp request is received, the CSP Server creates an instance of the %CSP.Request class. This is accessible via the %request variable. It holds all information about the call.Also all CGI variables. HTTP_REFERER might be what you look forand that's all core HTTP
go to post Robert Cemper · Jun 15, 2021 maybe a misunderstanding. if you execute a HTTP request YOU are the visitor at that side and get a response.do you look for your own IP address?
go to post Robert Cemper · Jun 15, 2021 Hi Nigel, I experienced this missing UNINSTALL feature several times filling up my working environment.So I adopted this strategy:- if there is no Docker container in the project I instal one of the prepared templates- As packages are (or should) independent of the platform I enter the container and install it theresimply running docker-compose exec -u root iris bash and execute the installationand when finished just removing containers and images and I'm back to roots.It only fails if I run against the 5 connections limit of the community license. But that's untypical.
go to post Robert Cemper · Jun 9, 2021 OK: %ALL means really all.- no surprisein your list, I miss role %SQL which gives access to all INFORMATION_SCHEMA.*as @Vic Sun just pointed out
go to post Robert Cemper · Jun 8, 2021 no qspec required. USER>set file="box.xml" USER>set sc=$system.OBJ.Export("box.GBL",.file) Exportieren in XML gestartet am 06/08/2021 11:46:58 Exportiere Global: ^box Export erfolgreich abgeschlossen. USER>$type box.XML <?xml version="1.0" encoding="UTF-8"?> <Export generator="Cache" version="25" zv="IRIS for Windows (x86-64) 2021.1 (Build 209U)" ts="2021-06-08 11:46:58"> <Global> <Node><Sub>^box</Sub> <Node><Sub>1</Sub> <Node><Sub>1</Sub> <Data> </Data> <Node><Sub>0</Sub> <DataBase64>G1syOzRI </DataBase64> </Node> <Node><Sub>1</Sub> <Data>1</Data> </Node> <Node><Sub>2</Sub> <Data>...456..9</Data> </Node> </Node> <Node><Sub>2</Sub> <Data> </Data> <Node><Sub>0</Sub> <DataBase64>G1syOzEwSA== </DataBase64> - - - - removed ------- </Node> </Node> <Data> </Data> USER>
go to post Robert Cemper · Jun 8, 2021 I think $system.OBJ.Export() with type .GBL .I don't have qspec at hands
go to post Robert Cemper · Jun 6, 2021 elementary differences: DO executes a method or subroutine synchronous to your code JOB starts an asynchronous job in background See onlinme docu how tp pass parametershttps://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=TCOS_DOhttps://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=RCOS_cjob
go to post Robert Cemper · May 25, 2021 Ok. this is not MS-SQL.Connect with your Studio to the correct Namespace and print out the related ClassMethod. This would most likely be some code in ObjectScript and not look like SQL
go to post Robert Cemper · May 24, 2021 ownership is typically irisowner:irisuser.Apply chown to the iris directories & files
go to post Robert Cemper · May 23, 2021 You are most likely blocked by a firewall on the way to your installation
go to post Robert Cemper · May 22, 2021 instead of simple ls run ls -l to see who is the owner.most likely it's the user that installed iris.to fix it run sudo chmod . . .
go to post Robert Cemper · May 21, 2021 I did this more than a year ago. It was quite some effort but it worked nicely.But I was blocked by ISC and got under pressure not to publish it for copy-right reasons.So be careful not to have this same conflict. Pls. don't ask for details!
go to post Robert Cemper · May 20, 2021 OK! Thanks for resolving the miracle! And we just learned IRIS does JSON . . . more or less . . . some times . . . somehow . . . fuzzyA real enlightenment that I was not aware of !
