Where Named Query execution

General Discussion
,
1

Hi,

not sure this have been asked before.
If we run the NamedQuery, where the execution will be process ?
is it on the Ignition server or is on the SQL server ?

Thank you

2

Both, really.

The query is issued from the Ignition Gateway but it's the database that plans and executes the query.

3

Currently I'm trying to select data with millions of data.
I'm trying to managed the memory allocation.

Let say I'm trying to query. the query process will be on SQL server and Ignition will received the result,
am I correct ?

I'm trying to avoid the Ignition become slow because of bad management on the query of the data.

Thank you

4

Yes, Ignition will receive the data, and if you query result has millions of rows it can cause issues with memory usage on the Ignition side.

5

Hi Kevin,

Thanks for the answer.
Definitely will avoid to return big data or at least using paging for tables.