I also will insert my five kopecks.

• The %Library package also includes stream classes, but those are deprecated. The class library includes additional stream classes, but those are not intended for general use.
  Working with Streams

  I have %Stream.FileCharacter was an order of magnitude faster than %[Library.]File

• If you rewrite the line-by-line reading to read blocks with further parsing of lines, the speed will more increase by an order of magnitude.
  
   

  Sample

  Class dc.test [ Abstract ]
  {
  
  ClassMethod ReadCSVStream(fCSV As %String) As %String
  {
    s stream = ##class(%Stream.FileCharacter).%New()
    d stream.LinkToFile(fCSV)
  
    s time1=$zh
    While 'stream.AtEnd {
      s line=stream.ReadLine($$$MaxLocalLength)
    }
    s diff=$zh-time1
    
    q diff
  }
  
  ClassMethod ReadCSVStreamBlock(fCSV As %String) As %String
  {
    s stream = ##class(%Stream.FileCharacter).%New()
    d stream.LinkToFile(fCSV)
  
    s i=0,time1=$zh
    While 'stream.AtEnd {
      s chunks($i(i))=stream.Read($$$MaxLocalLength)
      // do parsing chunk to lines
    }
    s diff=$zh-time1
    
    q diff
  }
  
  ClassMethod ReadCSVOURC(fCSV As %String) As %String
  {
    o fCSV::1 
    e  q "Missing File"
  
    s eof=$zu(68,40,1)
    u fCSV
  
    s time1=$zh 
    f  {
      r line
      q:$zeof
      // do something with line
  
    }
    s diff=$zh-time1
  
    c fCSV
    d $zu(68,40,eof)
  
    q diff
  }
  
  /// d ##class(dc.test).Test()
  ClassMethod Test()
  {
    s ptr=0,
      clnm=$classname()
  
    &sql(select %dlist(Name) into :list
         from %Dictionary.CompiledMethod
         where Parent=:clnm and Name %startswith 'ReadCSV'
         group by Parent
         order by SequenceNumber)
    
    while $listnext(list,ptr,m) {
      w !,"[",m,"]",?20,"execution: ",$classmethod(clnm,m,"data.csv"),!
    }
  }
  
  }

• On the Internet, you can find a lot of materials about comparing the speed of reading files (in particular CSV) for different programming languages (Python, C/C++, R, C#, Java, etc.), for example (this is machine translation). Often, those who make such comparisons do not always know all these languages equally well, so sometimes casus happen.
  
   

  Who do you think in the article above was faster when reading 1e7+ lines: Fortran or C++ ?

  Fortran :)
• If we approach the issue formally, then the advantage will be given to compiled languages, not interpreted ones, as well as the implementation that uses all the capabilities of the operating system and hardware.

Addition to the above: Speedup SQL pagination

Apache™ FOP: Fonts

Methods

See Base64EncodeStream

Or %Atelier.v1.Utils.General:Base64FromStream()

See documentation: $ZF(-100) requires the %System_Callout:U privilege. And check "Error Handling".

Why not use numeric codes?

$ascii("á") = 225
set s1=$zconvert("Flávio","I","HTML"),
    s2=$zconvert("Flávio","I","HTML")
   
write s1,$select(s1=s2:" = ",1:" <> "),s2

You are implicitly using %Library.SqlQuery:Func() method, in which, as @Robert Cemper rightly pointed out, $get() is used.

You can do it differently:

Query GetInfo(pObject AS Kurro.MyClass) As %SQLQuery(CONTAINID = 1, ROWSPEC = "IdList:%String,IdProcess:%String,Duration:%String") [ SqlProc ]
{
    SELECT IdList, IdProcess, Duration
    FROM Kurro.MyClass
    WHERE KeyProcess = :pObject.KeyProcess
    AND CodeSpecialist = :pObject.CodeSpecialist
    AND CodeProvider = :pObject.CodeProvider
    AND CodeCenter = :pObject.CodeCenter
    AND "Date" = :pObject.Date
}
set obj=##class(Kurro.MyClass).%New()
set obj.KeyProcess="1033004-1#"
set obj.CodeSpecialist = "surgery"
set obj.CodeProvider = "PR002"
set obj.CodeCenter = "CENTER-01"
set obj.Date = $ZDATETIME($ZDATETIMEH("2021-04-30 15:45:00",3,1),3,1)
set st=##class(%SQL.Statement).%New()
set sc=st.%PrepareClassQuery("Kurro.MyClass","GetInfo")
  if $$$ISERR(sc) {write "%PrepareClassQuery failed:" do $System.Status.DisplayError(sc) quit}
set result=st.%Execute(obj)
do result.%Display()

I don't quite understand what you want to get.

If in the forehead, then so:

Select v.valueId, m.name 
 From (Select 1 valueId Union Select 2 Union Select 3 Union Select 4 Union Select 5) v
     left Join otherTable m
        on m.id = v.valueId

But you can achieve the same thing more easily through IN or %INLIST.

You can easily do this by replacing two values in the registry.
Just checked on Caché & IRIS: SMP and Terminal (##class(%SYS.System).GetInstanceName()) displays the new instance name.
Upgrade/Deinstall work fine too.

If desired, you can also replace the service names (private Apache, etc.).

Apparently, you have autocompile enabled for the CSP application: Automatic and Manual Page Compilation And also check the parameter Recurse