go to post Robert Cemper · Jul 12, 2021 leaving aside that there are evident typing errors that break the codeyour reply underlines that the criteria: "Shortest answer wins!"misses the precise definition of what is measured.There is not much chance to be shorter than "x x q o" (= 7 char)
go to post Robert Cemper · Jul 10, 2021 Out of curiosity, I checked the size of the underlying OBJ code:> object size = 380 (+47% !) + timestamp = 18 So the expected gain is not what you would assume at first sight.For the price of an almost unreadable code
go to post Robert Cemper · Jul 9, 2021 Sorry, I never touched Angular I only know where it is coming from.
go to post Robert Cemper · Jul 8, 2021 my 1st attempt: N(t) s a="Alfa,Bravo,Charlie,Delta,Echo,Foxtrot,Golf,Hotel,India,Juliett,Kilo,Lima,Mike,November,Oscar,Papa,Quebec,Romeo,Sierra,Tango,Uniform,Victor,Whiskey,Xray,Yankee,Zulu" f i=1:1:$l(t) s %=$E($zcvt(t,"U"),i) w $s(%?1A:$p(a,",",$a(%)#32)_" ",%=" ":"",1:%) Line1=174 Line2=84 Total=258
go to post Robert Cemper · Jul 4, 2021 I come from Vienna, Austria.I guess we are "neighbors" according to your mail (.si)
go to post Robert Cemper · Jul 4, 2021 Zdravo Matjaž!you are right in principle. Though there are hundreds of similar cases since DECADES!ok, the cleaner solution brings us back to my previous proposal.add a calculated property to your serial class ##class(Packing.Needs.Attributes) like this Property List As %List [ Calculated, SqlComputed, SqlComputeCode = { set {*}= $LB({attr1},{attr2},{attr3},{attr4} ) }, SqlComputed ]; attr1,attr2,attr3,attr4 have to be the SQLnames of these properties !!! WARNING#1: you have to maintain this list manually at every change of the attributes! WARNING#2:: this calculation happens at every access to the object. The additional parameter SqlComputeOnChange = (attr1,attr2,attr3,attr4) may reduce this. though I've never tried in practice
go to post Robert Cemper · Jul 4, 2021 Ok. the picture becomes clearer: %SerialObject is stored as $LB($LB(....),...)you can get your result by 2 steps. do attribute.%SerializeObject(.serialraw) set list=$list(serialraw)
go to post Robert Cemper · Jul 3, 2021 don't think so complicated. leave your serial object as it isbut use instead a CALCULATED, SQLCOMPUTED Property as $LB() and you can then index it
go to post Robert Cemper · Jul 3, 2021 IRIS includes a bunch of "legacy" routines".Typically %R*, %G* that you can load by "legacy" commands in a "legacy" session or terminal(not webterminal or simliar commandline simulatiors)They are hidden in some way, It is not specific to VSC but the same with Studio.Though ZL %RI ZS %zRI should create a routine that you can work on. Z*,z*%Z*,%z* is writable Use code
go to post Robert Cemper · Jul 2, 2021 my PullRequest is pending.IMAGE=intersystemsdc/iris-community:2019.4.0.383.0-zpmis broken as it starts with SHELL ["/irissession.sh"]instead of SHELL ["/bin/bash", "-c"] Newer imags don't have that problem
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?
