All
Accepted answers
Robert Cemper · Dec 26, 2019 go to post

A few recommendations to improve performance:

#1) %TimeStamp  is a nice thing for display tough rather inefficient for indexing as it is mostly close to a unique index.
If you just check for Date as you describe you better use an index on a calculate property of type %Date
instead of a string, your date values in index are just integers !!! 
that makes your index slim and fast.

#2)
check for = is the easiest one, therefore, the fastest
check for > is the slowest as you have no stop condition
between is somewhat better as you have to check > and <  but you have a start / stop delimited range.

And integer compare is by dimensions faster than any string compares with any available processor chip.
And you do lots of them!

in reality, better check the number of Global references and lines you execute.
That's the truth.  Costs are good guesswork based on generic parameters out of tune table but rather for the dimension.

Robert Cemper · Dec 25, 2019 go to post

SUPER !  yes

less scrolling = easier to foloww the contents.

A real Xmas gift!  angel

Congrats & best wishes

Robert Cemper · Dec 22, 2019 go to post

@Kenneth.Poindexter8571   this is correct
though the result might be disappointing.
 
See: >ping www.intersystems.com

Antwort von 172.227.166.122: Bytes=32 Zeit=22ms TTL=55

But:

USER>w $system.INetInfo.AddrToHostName($C(172,227,166,122))
a172-227-166-122.deploy.static.akamaitechnologies.com
USER>
 

Robert Cemper · Dec 20, 2019 go to post

map  your MS SQL Table to a class using SQL gateway

in Studio create a new CSP page

<html>
<head> <!-- Put your page Title here -->
<title> Cache Server Page </title> </head> <body>
<!-- Put your page code here -->
My page body
</body>
</html>

use Tool / Templates  / WebForm Assistant
select your Class and the Properties you need
compile  it
use it

Robert Cemper · Dec 12, 2019 go to post

Great to see the subject coming up.

Especially as I had a very personal relationship to it starting with version -2 (SpeedMiner??)
or so before it was named DeepSee 1.

yes  yes  yes​​​​​​​  yes​​​​​​​  ​​​​​​yes​​​​​​​  

Robert Cemper · Dec 2, 2019 go to post

Sorry. My DOCKER is a Windows version. Iris is Ubuntu.
So it is UBUNTU inside Windows.  

Robert Cemper · Dec 1, 2019 go to post

just tried your line:

My docker is slightly older. 

Checked it on Ubuntu server

rcemper@TEST:~$ sudo bash
[sudo] password for rcemper:
root@TEST:~#

root@TEST:~# docker --version
#Docker version 19.03.4, build 9013bf583a

And this one runs on WIN10
>docker --version
Docker version 19.03.4, build 9013bf5

Same result for both of them:

>docker container run -it -p 51773:51773 -p 52773:52773 -p 5001:5001 -p 5000:5000 --name rcc2 --rm store/intersystems/iris-community:2019.3.0.309.0
[WARNING] No init process detected!  This container may accumulate zombie processes if run for a long time.  Consider using "docker create --init ..." or equivalent.
[INFO] Starting InterSystems IRIS instance IRIS...
[INFO] This copy of InterSystems IRIS has been licensed for use exclusively by:
InterSystems IRIS Community
Copyright (c) 1986-2019 by InterSystems Corporation
Any other use is a violation of your license agreement
Starting IRIS

12/01/19-22:24:43:883 (397) 0 [Generic.Event] Automatically configuring buffers
12/01/19-22:24:43:959 (397) 0 [Generic.Event] Allocated 421MB shared memory: 249MB global buffers, 35MB routine buffers
12/01/19-22:24:43:961 (397) 0 [Crypto.IntelSandyBridgeAESNI] Intel Sandy Bridge AES-NI instructions detected.
12/01/19-22:24:43:975 (397) 0 [WriteDaemon.UsingWIJFile] Using WIJ file: /usr/irissys/mgr/IRIS.WIJ
12/01/19-22:24:43:976 (397) 0 [WriteDaemon.CreatingNewWIJ] Creating a new WIJ file
12/01/19-22:24:45:445 (397) 0 [WriteDaemon.CreatedNewWIJ] New WIJ file created
- - - - 

Robert Cemper · Dec 1, 2019 go to post

Hi  

We used this @ german symposium: 

>docker images
REPOSITORY                          TAG                 IMAGE ID            CREATED             SIZE
store/intersystems/iris-community   2019.3.0.309.0      ccc1f07e75b6        2 months ago        1.33GB

>docker run -it -p 51773:51773 -p 52773:52773 -p 5001:5001 -p 5000:5000 -v c:\DockerData\:/data --name rcc2 --rm ccc1f07e75b6
[WARNING] No init process detected!  This container may accumulate zombie processes if run for a long time.  Consider using "docker create --init ..." or equivalent.
[INFO] Starting InterSystems IRIS instance IRIS...
[INFO] This copy of InterSystems IRIS has been licensed for use exclusively by:
InterSystems IRIS Community
Copyright (c) 1986-2019 by InterSystems Corporation
Any other use is a violation of your license agreement
Starting IRIS

12/01/19-19:13:57:734 (397) 0 [Generic.Event] Automatically configuring buffers
12/01/19-19:13:57:808 (397) 0 [Generic.Event] Allocated 421MB shared memory: 249MB global buffers, 35MB routine buffers
12/01/19-19:13:57:810 (397) 0 [Crypto.IntelSandyBridgeAESNI] Intel Sandy Bridge AES-NI instructions detected.
12/01/19-19:13:57:825 (397) 0 [WriteDaemon.UsingWIJFile] Using WIJ file: /usr/irissys/mgr/IRIS.WIJ
12/01/19-19:13:57:825 (397) 0 [WriteDaemon.CreatingNewWIJ] Creating a new WIJ file
12/01/19-19:13:58:490 (397) 0 [WriteDaemon.CreatedNewWIJ] New WIJ file created
12/01/19-19:13:58:493 (397) 0 [Generic.Event]
Startup of InterSystems IRIS [IRIS for UNIX (Ubuntu Server LTS for x86-64 Containers) 2019.3 (Build 309U) Wed Sep 11 2019 16:20:03 EDT]
        in /usr/irissys/bin/
        with mgr: /usr/irissys/mgr
        with wij: /usr/irissys/mgr/IRIS.WIJ
        from: /usr/irissys/mgr/
  OS=[Linux], version=[#1 SMP Tue Jul 2 22:58:16 UTC 2019], release=[4.9.184-linuxkit], machine=[x86_64]
  nodename=[e3f43e3bfd15].
  numasyncwijbuf: 0, swdwrtmax: 0, wijdirectio: off, synctype: 3
  System Initialized.
12/01/19-19:13:58:504 (398) 0 [WriteDaemon.Started] Write daemon started.
12/01/19-19:13:59:795 (409) 0 [Database.MountedRW] Mounted database /usr/irissys/mgr/ (SFN

and it works as expected .
  But I used no durable feature !!  
 

Robert Cemper · Dec 1, 2019 go to post

Thanks for the clarification. 
It's a rare chance I might be up at that early time smiley 
and if my body is it doesn't mean my brain is too.

Robert Cemper · Dec 1, 2019 go to post

Could someone explain to a newcomer what the time is telling me  ?

Any local time  (lokes like EST) ?  or some total ???

     --------Part 1--------   --------Part 2--------
Day       Time   Rank  Score       Time   Rank  Score
  1   11:37:18  15816      0   11:50:08  14212      0
Robert Cemper · Dec 1, 2019 go to post

what is the  join code for ObjectScript Leaderboard 
I get asked for ??
 

You can join a private leaderboard by entering its join code here:

 

--- Your Private Leaderboard ---

You don't have a private leaderboard. You can only have one. You can [Create It] now.

Robert Cemper · Nov 30, 2019 go to post

mine is Windows.

I just tried it with the Symposium (Docker, UBUNTU)  ==> Community Version + Key

License Capacity  InterSystems IRIS Community license
Customer Name  InterSystems IRIS Community
Order Number  54702
Expiration Date  10/30/2021
Authorization Key

8116600000500000500008000084345EF8F2473A5F13003
Product=Server
License Type=Concurrent User
Server=Single
Platform=IRIS Community
License Units=5
Licensed Cores=8
Authorized Cores=8
Extended Features=3A5F1300

. . . 

. . . 

Atelier required a restart but then it worked.

WELL: default in Ubuntu / Docker : firewall off
I fear Red Hat is different. But my last Red Hat is 15 yrs back :-(

My personal decision was to move to Docker because it is really easy after 1/2 day playing with basics.

Robert Cemper · Nov 29, 2019 go to post

Hi Udo,

I tried it with my 1 year old  Atelier installation.
Setup of a new sever connection.
The test showed me:

 

OK so I changed to PASSWORD only

 

AND the test worked OK.   And access as well..
 

Robert Cemper · Nov 29, 2019 go to post

you either remove the reference to the object
or terminate the process that holds the references.

Robert Cemper · Nov 29, 2019 go to post

The added %XML.Adaptor  is not active until the related object is closed and a new instance of it  is opened again.

Robert Cemper · Nov 28, 2019 go to post

check license usage in SMP/Operations

Check CSP Session as well

In Security / Application force authentication not to lose licenses to Unknown user,
It is not to comfortable but may help.

BTW. my preview licenses had all features but NO users.  I kicked them as useless.

Robert Cemper · Nov 28, 2019 go to post

You are on the right way.
It has to be a SYSTEM DSN.

in win10 clich to start
then click the GEAR symbol
next search for ODBC and you should be there.

OR

search from  WINDOWS control panel -> administration ->  ODBC data sources (64bit)  -> System DSN

Robert Cemper · Nov 25, 2019 go to post

sorry. this was done by a PHP developer back in 2008/2009.

the <Caché side was default from the wizard.

I have no idea about the details anymore.

Robert Cemper · Nov 21, 2019 go to post

$system.UpgradeAll("",.ERRLOG)  may give you a hint on problems.

Studio sticks with dictionary version. If there is a mismatch Studio refuses. And Mgmt Portal only shows Class documentation.

I'm not so familiar with Healthshare: Is there eventually some Read/Only DB involved that blocks Update ?
I think of class... EXTENDS (read/only class), ENSLIB ???

Robert Cemper · Nov 18, 2019 go to post

I faced a similar issue some years back.

As PHP is so close to web servers I decided to use a WebsService to call the ClassMethod aka Procedure.
It was easy on both ends and I could avoid the ODBC module (at that time only 32bit)

Robert Cemper · Nov 16, 2019 go to post

I'd expect better text search in a source control repository.
Anyhow there is either a bug or a setup problem related to your Error msg in Atelier.

Do you have any Windows based PC available to use Studio ?

Robert Cemper · Nov 16, 2019 go to post

This routine is mapped to another database, are you sure you want to change it??
 No => yes%DIRFULL.INT
 

reply with NO  (default) and you won't change any %*routine if you work from your namespace (RPMS?)