1. Beatrix Willius
  2. Valentina Studio
  3. Четверг, Март 01 2018, 05:14 AM
  4.  Подписаться через 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
Комментарий
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. 0 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories
Omegabundle
  1. 0 subcategories