SQL Connector - Queries counter

Need help Database
1

Hi everyone,

I am successfully using the Plugin SQL Connector (it’s great and really fast!).

I just have an easy question: is it possible to keep track of how many times a query is called? For the sake of stats (and to better understand how many concurrent connections I will have to handle) I would like to know how many queries are called by even user. Do you think this is possible?

My queries are all ‘called’ just inside RG and not as actions, so I don’t see a way to set up a counter to update every time the query is executed.

Extra: when is the query executed? When the RG is loaded? When page is reloaded? Every time I have a change in a parameter? Is it called again if I e.g. ‘go to previous page’ where my RG was displayed?

Thanks!
Carlo

2

This is a great video by @TipLister on tracking actions in an app:

3

Thanks Carlos for your reply and for the interesting video.
By the way, this does not really solve my problem. I have for example an input which updates live an SQL Query, so I have no buttons and no workflows, but just the input and the RG. I would like to know ho many times the connection is on to better understand how many concurrent connections I could handle.

Thaanks

4

You could use the event “when an input value is changed” to monitor your inputs and create a thing that you can call “query” every time someone uses an input. Would be better to send this action to a backend flow scheduled a few minutes in the future :+1: