go to post Robert Cemper · Sep 14, 2021 Hi @Jack Huser,I assume you would agree it is fair to compare apples to applesbut not horse coaches to formula-1 cars.Being proud that I never lost a benchmark by speed I rewrote your codethat is nice to read and maintain but not very efficient, going for somethingmore speedy to show the limits and then checked it against your class.My test file has only 47MB containing 181566 lines. DEMO>write ##class(JUH.Test).ReadFile(file) execution: 214.931024 1 DEMO>write ##class(JUH.Test).ReadQuick(file) execution: .753696 lines: 181566 1 DEMO>write .753696/214.931024*100_" %" .3506687801385062028 % I think 0.35% is quite an eye catcher. And his is the class: ClassMethod ReadQuick(strINReadFile As %String = "") As %Status { open strINReadFile::1 else write "Missing File",! quit '$$$OK set eof=##class(%SYSTEM.Process).SetZEOF(1) use strINReadFile set time1=$zh for line=0:1 { read strBuffer if $zeof set diff=$zh-time1 quit // do something with strBuffer } close strINReadFile do ##class(%SYSTEM.Process).SetZEOF(eof) write !,"execution: "_diff,!,"lines: ",line,! quit $$$OK } I just couldn't resist my nature.
go to post Robert Cemper · Sep 13, 2021 run a community container withZPM loaded e.g. intersystemsdc/iris-community:2020.4.0.547.0-zpmand then from irisessionzpm "install webterminal" this should do all you need
go to post Robert Cemper · Sep 13, 2021 For this query, I would suggest to define this index: Index iFilter on (KundenNr,ErfassungsartBez,DatumAuftrag) ; The sequence of KundenNr,ErfassungsartBez,DatumAuftrag should by increasing selectivityAs found in Tune Table output (SMP > SQL > Actions > TuneTable)
go to post Robert Cemper · Sep 13, 2021 I did further investigations on 'broken' input files and placed a related issuehttps://github.com/MakarovS96/cache-tort-git/issues/8It happened a little bit by accident but I found this a possible realistic scenario that explainswhy the problem occurs every now and then. You may argue this is bad handling by user.Accepted. But not unlikely.I found this situation: I have a project. with several packages and classes I deleted a class BUT the PACKAGE was not saved and didn't reflect the change From ClassMethod ExportProject(project ,1) I get this strange XML for the deleted class c:\temp\TEST\dc\MyCompany\EmployeRegister1.cls.xml <?xml version="1.0" encoding="UTF-8"?> <Export generator="IRIS" version="26"> </Export> now I need a GIT expert to analyze what happens with this incomplete input. my assumption: according to the file name there is an empty entry of type CLS named /dc/MyCompany/EmployeRegister1.cls.xml or similar when ist is restored it may cause the described problem togehter with the reported bug in $system.OBJ.Load()
go to post Robert Cemper · Sep 12, 2021 my pull request is posted https://github.com/MakarovS96/cache-tort-git/pull/7
go to post Robert Cemper · Sep 12, 2021 Finally, the docker image now builds OK and contains all required classes & all globals.( + also the bug in dc.script.Genre.cls was fixed) Connection to local PowerBi now works and shows the expected images.Thanks for fixing it.I was somewhat surprised that IRIS Analytics was not required at all since therewas no Cube nor Pivot nor Dashboard. I built it myself just using dc.dc.bi.PopSongs.OK. PowerBI graphics look better.But here is not the place to comment on ZEN graphics.
go to post Robert Cemper · Sep 11, 2021 no chance. M$ wants a corporate e-mail. I have no corporation.confirms my personal opinion on M$ products I can only use the free download version.
go to post Robert Cemper · Sep 11, 2021 When I downloaded your Repo from GitHub the docker image generated.But I just see just NOTHING inside the container of the dc.* classes or globals that are in the repoI couldn't find any cube or pivots or dashboards. Neither in the container nor in the repo.Not just me, also Power BI just found NOTHING.What do you expect me to vote for ?Sorry.
go to post Robert Cemper · Sep 10, 2021 I was unable to reproduce it in InterSystems Studio Client 2021.1.0 Build 205maybe some older version ?
go to post Robert Cemper · Sep 10, 2021 I placed a prodlog on the strange behavior of $system.OBJ.Load()PRODLOG 951065
go to post Robert Cemper · Sep 10, 2021 As seen in my comment I can reproduce the error pattern and show some really dirty effects.Someone willing to debug this source control and expose his SYSLIB may be the winner.
go to post Robert Cemper · Sep 9, 2021 from class docs: • property Server as %String(MAXLEN=64,MINLEN=0); Name of the remote server where the DB resides.If empty, the database is local.Remote server must already be configured to be entered here. so this applies if you have some ECP connected DBs
go to post Robert Cemper · Sep 9, 2021 omit the server name and just use "" for your local server %SYS>set db=##class(Config.Databases).DatabasesByServer("",.dbList) %SYS>zw db=1 dbList="DEMO,IRISSYS,CACHE,ECODE,EDATA,ENSLIB,IRISAUDIT,IRISLIB,IRISLOCALDATA,IRISTEMP,USER" %SYS>
go to post Robert Cemper · Sep 8, 2021 https://docs.intersystems.com/iris20211/csp/docbook/DocBook.UI.Page.cls?KEY=RCOS_fzdate write $zd(+$h,4,,4)
go to post Robert Cemper · Sep 5, 2021 s max=0,glb="^MyGlobal" f s glb=$q(@glb) q:glb="" s:$ql(glb)>max max=$ql(glb) zw max