Idea for contestants.

Julyter Notebooks kernel for InterSystems ObjectScript.

Recently I developed bidirectional integration for Jupyter Notebooks. It allows you to create intelligent Business Processes with Python activities. Here's the code (it uses Native API for Python and there's less than a 1000 sloc in the whole integration). Here's some screenshots:

However, as you see currently only BPLs with Python are supported.

The idea for the app is simple - to do the reverse - add the ability for Julyter Notebooks to execute InterSystems ObjectScript code.

Why? It's a great tool for quick prototyping and demos!

How? Using Native API develop a wrapper kernel for InterSystems ObjectScript. Essentially all you need to do is to execute arbitrary string of code and return result. Check WebTerminal source code (by @Nikita Savchenko) to see how a similar application works.

Docs:

• Wrapper Kernel docs
• List of Kernel Implementations
• More docs (all possible approaches)

As second argument defaults to 1 and third can be skipped you can write just:

if $e(chunk)=""""{
}

Calling @Stefan Wittmann 
 

Try

$$$TRACE("LastChecked value is: '" _ LastChecked _ "', compare: " _ (LastChecked="undefined"))

You can add this to your code

$$$TRACE("LastChecked value is: '" _ LastChecked _ "'")

to get LastChecked value.

Without reports suggested by other users there's not much I can tell you.

What are global buffer sizes on prod/dev machines?

Preheat global cache by looping over data global and compare the timings after that.

List of utilities/reports that should help you:

• pButtons – all info you  might need, open the ticket with WRC with this info.
• mgstat –main metrics
• PERFMON – get most used globals/routines
• GLOSTAT – system metrics
• %SYS.MONLBL – line by line code profiling
• GLOBUFF – global buffer analysis

Check this series of articles by @Murray Oldfield.

it's composite primary key, and I have good reasons for it.

Which are?

Can you compare the performance to index opening:

s p=##class(digi.packet).IDKEYOpen("packet", 5237)

Any particular reason your id is not an integer?

I'd think it's a parent-child relationship but why a parent id is a string?

but an approach could be with one client request end it, and return a new one

What for? Ending the session means the client exited. You can add additional user supplied cookie(s) and check/modify/delete them as you wish. On every request even.

The other option as mentioned is to encript trafic and therefore the cookie can no longer be used.

Cookies absolutely can be used with encrypted traffic. HTTP/HTTPS makes no difference for cookies sent by a browser.

That is right, but as long as the cookie session timeout is valid (let's say 60 seconds) anybody that intercepts that cookie is effectively authenticated as long as the timeout is valid.

Only as long as they share the same remote address. HTTPS offers additional protection. Really if someone can decode your HTTPS traffic to get the cookie you have a bigger problem.

Isn't there any way of invalidating a sessionID manually and creating a new one?

Ends the session. Next request starts the new session.

The webinar is tomorrow!

Check StatementAttrs setting. It's a set of SQL Statement Attribute Options of the form attr:val,attr:val,...
Do this in your Business Operation's OnInit method:

Set ..Adapter.StatementAttrs="QueryTimeout:12"

You can try this to create XLSX files from SQL queries (in the same project there's also XLS exporter).

Another option would be to export CSV and use LibreOffice to convert it to XLSX (among other formats). Here's how.

First of all, I'd really like to recommend you to upgrade to InterSystems IRIS.

You can still set query timeout as a part of JDBC connection string if it is available in external DBMS implementations.