This IDKEYOpen looks as capricious beast. Because of some reasons digi.packet has no such method. But its sibling class do have it although in lowercase:

zidkeyOpen(K1,K2,concurrency=-1,sc) public { Set:'($data(sc)#2) sc=1
Quit ..%OpenId(K1_"||"_K2,concurrency,.sc) }

A few other classed  have IDKEYOpen in upper case:

zIDKEYOpen(K1,concurrency=-1,sc) public { Set:'($data(sc)#2) sc=1
Quit ..%OpenId(.K1,concurrency,.sc) }

Looks as the compiler generates this method only in some cases. But why in lower case? Strange.

What for the performance, the method looks as a very simple wrapper around %OpenId, so no much performance difference to expect.

You wrote:

if I was not concerned with concurrency as I just wanted to read data I would use option 0.

Just to see how much gain I can have, I compared options 0 and 1, and the diff is surprisingly small: the test with 0 takes 34 secs, and with 1 takes 35. I would expect a bigger difference.

Yes, for sure pure global reading is not the same as Open. With this test I just wanted to make sure the slowness is not related to global access speed.

No, this is not my case :) I've exact copy of the test method on each machine.

I can see some difference between the methods: with p existing, each next Open spends some time checking if the object already open.  But 12 times... I wonder what makes it.

Thanks for your time.

Yes, I can try it but how do you mean it is related to my problem? My problem is that my laptop executes very same code against very same database 6 times faster than powerful idle server.

Hi Alexander,

how did you realize that you have to adjust the buffers? What kind of problems you had?

Hi Eduard,

no, it is not parent-child relationship, it's composite primary key, and I have good reasons for it.

For sure there are tons of differences in the hardware! And the price is primary of them! The productions server cost is I guess like ten of my developing laptops. And this is one of the reasons I expect the server be fast :)

Thanks. Yes, I'm now automatically collecting execution time every 15 mins to check the performance overnight when all the users are gone.

Good idea! Never heard about BENCHLANG before. The server is almost idle at night time so now I know what it can do in its spare time.

>is there any other load on the server that could have influence ? 

The load is first explanation I had in mind.  But I've done the comparison several times with server load near to none.

Thanks. What do you mean with "run it in a loop"?

I've updated my post to make my intentions clear. 

I'm talking about the exposing of existing globals via SQL with Cache SQL Storage mapping. I.e. about subject of this post https://community.intersystems.com/post/art-mapping-globals-classes-1-3
 

Wow! A really nice hack! :) Well done!

Great! Thanks!  

Yes, now I can import it. But controls Direct View and the filter do not exist. And as just a side note, everything related to Ensable fails to compile on my Cache.

Would be nice to have a way to extend Portal with custom pages. This way colleagues need not to learn and store links to the pages. 

Can you say what min Cache version is supported? My Cache 217.2 fails to parse the xml.

>you develop this view by yourself

yes, that's clear. But what is "ad-hoc portal page"? A way to extent Management Portal with custom pages?