When executing a query with the SDK, any lookup values always include the associated record name and formatted values are always included in the results. For many applications this is unnecessary and only the raw values are needed.
Performance of these applications could be improved by introducing an optional parameter for the RetrieveMultiple message to eliminate this extra data. This would remove the need to include a join to each lookup table, giving simpler and faster SQL queries as well as less data to be transferred back to the client.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.