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\" )
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.