1. Beatrix Willius
  2. Valentina Studio
  3. Thursday, March 01 2018, 05:14 AM
  4.  Subscribe via email
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
Comment
There are no comments made yet.
Ruslan Zasukhin Accepted Answer
Hi Trixi,

please try in SQL Editor command "SHOW STATISTIC"
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 1
Beatrix Willius Accepted Answer
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
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 2
Ivan Smahin Accepted Answer
Hi Beatrix,

It must be something like this one:


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

SELECT * FROM __QueryStatistic__

Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 3
Beatrix Willius Accepted Answer
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
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 4
Ruslan Zasukhin Accepted Answer
Just in SQL. SqlExecute( "SET PROPERTY ... " )

wrapping queries you want to learn.

May be on start of your app - you choose.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 5
Ivan Smahin Accepted Answer
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__
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 6
Beatrix Willius Accepted Answer
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
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 7
  • Page :
  • 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