AnsweredAssumed Answered

Execute SQL very slow to fetch from Table with 287 Fields

Question asked by AlyDewji on May 6, 2018
Latest reply on May 7, 2018 by wimdecorte

I am running FM Server 16 and FM Clients on a WAN Network.


Typical Ping is:  3-15ms

 

My database contains a table with 287 Fields.

 

I am trying to run an execute SQL to fetch UUIDs from this table with 287 fields.

 

It is taking ages.  What am I doing wrong.

 

All fields that it is referenced to are uncalculated, indexed, throughout the chain.

 

ExecuteSQL ( " Select ( \"_kf_DTPR UUID\" )

from \"@DTPR__DTPR\"

where \"UUID_RL_Loading_List\" IS NULL

and \"Lookup_Current Corridor\" = ?

";

"" ;

"" ;

"Dar es Salaam Corridor")

 

This is my simple SQL statement.

 

Please help me as it is driving me crazy.

Outcomes