User bio
404 bio not found
Member since Apr 24, 2017
Posts:
Replies:
Thanks Eduard.
It seems the client missed some settings with their docker engine installation but we have not figured it out yet.
They reinstalled the docker env, make sure it was installed under root previlege then it worked.
Thanks for the help from @Stefan Cronje and @Vitaliy Serdtsev
I'm using the SQL
select count(1) from (
select distinct by (VISIT_SERIAL_NO,HQ_ORG_CODE) VISIT_SERIAL_NO,HQ_ORG_CODE
from %PARALLEL ST_SEARCH_VISIT
)
which ends in 2 seconds in my test env
Since the end user is expecting a query ends in 3 seconds, I'll test its performance with their other conditions combined.
Thanks again for the help.
Certifications & Credly badges:
Nicky has no Certifications & Credly badges yet.
Global Masters badges:
![Open Sesame!](https://community.intersystems.com/sites/default/files/badges/303371180-6de11138-f4e7-4113-b5cc-836269f07693.png)
![1,000 Points](https://community.intersystems.com/sites/default/files/badges/290121674-53216c4b-fe0c-44e7-9d75-2f24390135ed.png)
![Challenge Starter](https://community.intersystems.com/sites/default/files/badges/295959213-b83dd91a-663f-4f07-8e0e-e3287b7c2309.png)
![Popular writer](https://community.intersystems.com/sites/default/files/badges/poular_writer.png)
![Reporter Badge](https://community.intersystems.com/sites/default/files/badges/reporter_badge_0.png)
![Curious Member](https://community.intersystems.com/sites/default/files/badges/curious_member_badge.png)
![Thorough Member](https://community.intersystems.com/sites/default/files/badges/thorough_member_badge.png)
Followers:
Following:
Happy new year guys! 🔔