1. Beatrix Willius
  2. Valentina Studio
  3. 木, 3月 01 2018, 05:14 AM
  4.  メールで購読
Got the usual senior moment: how do I access system tables in Valentina Studio?

I want to check out the SQL monitoring. The wiki says:

After turn “IsMonitoring” property on you will see a new system table __QueryStatistic__


But where do I see this?

Mit freundlichen Grüßen/Regards

Beatrix Willius

http://www.mothsoftware.com
Mail Archiver X: The email archiving solution for professionals
コメント
There are no comments made yet.
Ruslan Zasukhin 承諾済みの回答
Hi Trixi,

please try in SQL Editor command "SHOW STATISTIC"
コメント
There are no comments made yet.
Beatrix Willius 承諾済みの回答
Hi Ruslan,

very good. I got this as result:

https://imgur.com/hHFkNE0.png

Where is the information about the SQL queries?

Mit freundlichen Grüßen/Regards

Beatrix Willius

http://www.mothsoftware.com
Mail Archiver X: The email archiving solution for professionals
コメント
There are no comments made yet.
Ivan Smahin 承諾済みの回答
Hi Beatrix,

It must be something like this one:


SET PROPERTY "IsMonitored" of DATABASE TO true;
...
-- your queries ..
...

SELECT * FROM __QueryStatistic__

コメント
There are no comments made yet.
Beatrix Willius 承諾済みの回答
Hm.... where and how do I need to do this exactly?

So far I set the property "isMonitored" in VStudio to true and quit VStudio. Then I opened my app which executes some queries. I quit my app and expected to see the result in VStudio. Do I need to do this only in VStudio? Only in my app? Some other combination?

Mit freundlichen Grüßen/Regards

Beatrix Willius

http://www.mothsoftware.com
Mail Archiver X: The email archiving solution for professionals
コメント
There are no comments made yet.
Ruslan Zasukhin 承諾済みの回答
Just in SQL. SqlExecute( "SET PROPERTY ... " )

wrapping queries you want to learn.

May be on start of your app - you choose.
コメント
There are no comments made yet.
Ivan Smahin 承諾済みの回答
It should be "__QueryStatistic__" system table after turn on "isMonitored" property. If this table exists and has an expected structure, any query's statistic (text + timing) will be there.
Could you just check:


SELECT * FROM __QueryStatistic__
コメント
There are no comments made yet.
Beatrix Willius 承諾済みの回答
Hi Ivan,

the query


SELECT * FROM __QueryStatistic__


works. Thanks!

Mit freundlichen Grüßen/Regards

Beatrix Willius

http://www.mothsoftware.com
Mail Archiver X: The email archiving solution for professionals
コメント
There are no comments made yet.
  • ページ :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories