Name query vs system.db script performance in perspective

Ignition
1

Hi
I’d like to is there difference in performance when using Name query vs system.db script in perspective?

May be there some performance optimization in name query.
Thanks

2

If you aren’t using caching in your named query, behind the scenes it’s using much of the same code as system.db.runPrepQuery(). If you’ve cached the results of your named query, then you do get some performance boost because the query will need to be executed less often.

1 Like