go to post Eduard Lebedyuk · Oct 13, 2016 What's speed are you getting? Rows per second and average size of row for example.Have you tried comparing that speed with direct iteration over a same resultset in COS?
go to post Eduard Lebedyuk · Oct 13, 2016 The largest pool size is recommended to be the same as the number of CPUs in the Ensemble server, since there are only going to be as many jobs available as the number of CPUs.Why should number of jobs be less or equal to the number of cores? I tested (admittedly only one) BP for processing some objects and results (messages processed per second) were better with PoolSize=100, than with PoolSize=50 on a system with 1CPU/8cores.
go to post Eduard Lebedyuk · Oct 12, 2016 Sorry, I posted a link to an old FieldTest version, it not available now. I replaced the link in my example with actual version, so it should work now (delete cookies.txt and both lines need to be executed again).
go to post Eduard Lebedyuk · Oct 11, 2016 You can write a dtl transformation or a generic business process which accepts object, dynamically gets a list of properties to convert (All %String properties? Some kind of a dictionary? Pattern?) and strips diacritic signs from them.
go to post Eduard Lebedyuk · Oct 7, 2016 If you have/use Ensemble you can check how EnsLib.SQL.CommonJ class operates.
go to post Eduard Lebedyuk · Oct 7, 2016 I use the following script (courtesy of Alexander Koblov): wget --delete-after --keep-session-cookies --save-cookies cookies.txt --post-data='UserName=?????&Password=???????' 'https://login.intersystems.com/login/SSO.UI.Login.cls?referrer=https%253A//wrc.intersystems.com/wrc/login.csp' wget --load-cookies cookies.txt --content-disposition 'https://wrc.intersystems.com/wrc/WRC.StreamServer.cls?FILE=/wrc/distrib/HS-2016.1.2.208.0-hscore15.01_hsaa15_hspi15_hsviewer15.01_linkage15-b6402-lnxrhx64.tar.gz' First line for authentication and saves cookies into a file. Second line loads cookies from file and downloads with file.
go to post Eduard Lebedyuk · Oct 6, 2016 You can call %KillCache method in a cubeclass. It does exactly that. For example: write ##class(HoleFoods.Cube).%KillCache()
go to post Eduard Lebedyuk · Oct 4, 2016 If you are on windows you may have access problems while writing into the root of system drive. I suggest you: Provide filename pointing to your desktop directory (C:\Users\eduard\Desktop\1.xls for me, for example)Instead of w ##class... save the status and decode it into a more readable form: set sc = ##class(Utils.XLS).generateFileFromSQL(...) write $System.Status.GetErrorText(sc)
go to post Eduard Lebedyuk · Oct 4, 2016 I think compile should be called once after the loop. While in the loop you can build a local array of affected classes and pass it to the compiler after the loop.
go to post Eduard Lebedyuk · Sep 27, 2016 You can expose this method to SQL as an SQL stored procedure.
go to post Eduard Lebedyuk · Sep 27, 2016 We have a google calendar (and map) integration for Caché as a part of System of training courses grant project. Check out Stc.Google package there, especially Stc.Google.Calendar class.
