Find

Announcement
· Sep 8, 2021

"New" Tool SQL DATA LENS for Intersystems IRIS

Dear ladies and gentlemen, in the last month I've improved my Tool Caché Monitor... but first: the name

The name Caché Monitor was chosen to reflect the close integration of the tool with the Caché database. The established name Intersystems Caché will likely be completely replaced by InterSystems IRIS Data Platform in the foreseeable future I think. So a rebranding step became necessary. In order to be less closely tied to a product name in the future, a new name has been chosen to be more neutral: SQL Data Lens

Regardless of the name, it is still the goal to implement the closest possible integration into the Intersystems products. The ongoing development is also reflected in the continuation of the release numbers: The last version is Caché Monitor 2.96, the next version is SQL Data Lens 3.0.

But it is not only a renaming, but also many new features have been integrated, e.g:

  • One big step is that SQL Data Lens is now based on the Java Runtime Environment 11, with that it was possilbe to improve the HiDPI support. The system scale factor is configured on the OS level, per-monitor DPI is supported!
  • But also a new and modern Flat Look and Feel is integrated, in light and dark mode.
  • SQL DataLens ist shipped with a minimized private JRE (based on JetBrains JDK 11)
  • ... and many more

Please feel free to download and test SQL Data Lens without any registration from: https://sqldatalens.com/

I look forward to your experiences, suggestions and ideas these are very welcome.  

Thanks for your attention!

Andreas

4 Comments
Discussion (4)2
Log in or sign up to continue
Announcement
· Sep 8, 2021

Video: Deploying & Upgrading IRIS with Kubernetes Operator

Hey Developers,

New video is already on InterSystems Developers YouTube:

⏯ Deploying & Upgrading IRIS with Kubernetes Operator

Extend your Kubernetes instance with the InterSystems Kubernetes Operator and learn the easiest way to deploy, upgrade, and expand your InterSystems IRIS data platform instance.

🗣 Presenter: @Steve Lubars, Distinguished Systems Developer, InterSystems 

Stay tuned!

Discussion (0)0
Log in or sign up to continue
Discussion (0)1
Log in or sign up to continue
Article
· Aug 30, 2021 2m read

クエリをチューニングする方法

これは InterSystems FAQ サイトの記事です。

InterSystems 製品には、テーブルのコンテンツに関する統計を収集し、クエリの最適化に役立てる「テーブルチューニング機能」があります。

設定方法は、以下のドキュメントをご参照ください。

ターミナルでは次のコマンドを実行します。

do $SYSTEM.SQL.Stats.Table.GatherTableStats("スキーマ名.テーブル名",1,1)

 

 2021.1以前のバージョンでは以下メソッドを利用します。

Do $system.SQL.TuneTable("スキーマ名.テーブル名",1,1)

 

また、以下の資料もご参照ください。

1) パフォーマンス調査の基礎知識として必要なグローバル構造の解説やSQLの動作の仕組みからクエリプランの見方の解説

インターシステムズ・シンポジア2011の資料

2) パフォーマンスチューニングの例(P13~)

インターシステムズ・シンポジア2012の資料

3) ビットマップ・インデックスの圧縮やオプティマイザ・ヒントなど、Caché SQLのパフォーマンスを最大限に引き出すための情報について

インターシステムズ・シンポジア2014の資料

4) パフォーマンスに困ったときにどこに着目し、どのツールで調べていくか、お客様から日々ご相談をいただくカスタマーサポートから、解決に向かうアプローチの「イロハ」をご紹介するビデオ

動画:Performance 101

5) 開発者コミュティのパフォーマンス関連情報(performanceタグ)

performanceタグ

 

関連する以下記事、FAQトピックも併せてご参照ください。

Discussion (0)1
Log in or sign up to continue
Announcement
· Aug 23, 2021

Meet the winners of the 1st Tech Article Contest!

Hey Community,

Our first InterSystems Tech Article contest is over. Lots of new content to read: 23 amazing articles 🔥

Big thank you to everyone who participated in our writing competition!

And now it's time to announce the winners... excited?

Meet the 1st Tech Article contest winners and their articles:

⭐️ Expert Awards – winners selected by InterSystems experts:

🥇 1st placeBILLIONS - Monetizing the InterSystems FHIR® Accelerator Service with Google Cloud's Apigee Edge written by @sween

🥈 2nd placeLearning Path for beginners written by @Yuri Marx 

🥉 3rd placeInterSystems IRIS REST Application Patterns written by @Yuri Marx 

⭐️ Community Award – winner selected by Community members, article with the most likes:

🎉 Winner: Let's fight against the machines! written by @Henry Pereira

⭐️ And let's meet some authors who contributed a number of articles to this competition:

WOW! For their great contribution, we'd like to reward these authors with a 🎁 Nike Utility Speed Backpack 🎁

⭐️ Let's congratulate all our heroes at community.intersystems.com/contests/1:

THANK YOU ALL! You have made an incredible contribution to our Dev Community! 

P.S. The prizes are in production now. We will contact all the participants when they are ready to ship - stay in touch!

So,

Awesome 1st Tech Article contest, isn't it?

Thanks to all the participants for the efforts you pay in our 1st exciting writing contest!


And what's next.....?

Stay tuned for the next InterSystems Tech Article contest 😉

7 Comments
Discussion (7)2
Log in or sign up to continue