AnsweredAssumed Answered

executeSQL() and PSoS:  where does eSQL evaluate?

Question asked by wxtyrs on Aug 9, 2018
Latest reply on Aug 10, 2018 by coherentkris

I use executeSQL() to lookup in unrelated tables ≈30 text values related to codes within a given record.

 

The main table will have >2-5 million records.  The records are, presently, wide: ≈100 fields.

 

The data model has not been normalized for particular reasons - hence the width.

 

To enable concurrent lookups and improve performance, I planned to run eSQL routines using PSoS.

 

However, other forum posts indicate, eSQL queries are run on the client, not server, with all the overhead performance costs thus associated with client-based routines that use wide records.

 

This a single user app; not multi-user.  It simply transforms data from one form to another.

Outcomes