Microsoft Dynamics NAV - C/SIDE Solution Development -

Microsoft Dynamics NAV – C/SIDE Solution Development

Locus IT ServicesMicrosoft Dynamics NAV – C/SIDE Solution Development

Lesson 7: C/AL Database Functions and Performance on SQL Server

C/AL Database Functions and Performance on SQL Server GET, FIND, and NEXT

C/AL Database Functions and Performance on SQL Server : The C/AL language offers several methods to retrieve record data. Each of the following functions is optimized for a specific purpose. To achieve optimal performance you must use the method that is best suited for a given purpose.

  • GET – This function is optimized for retrieving a single record based on primary key values.
  • FIND – The FIND function is optimized for retrieving a single record based on the primary keys in the record and any filter or range that was set.
  • FIND(‘-‘) and Record.FIND(‘+’) – These functions are optimized for reading an open-end dataset when the application might not read all records.
  • FINDSET(ForUpdate, UpdateKey) – The FINDSET function is optimized for reading the whole set of records within the specified filter and range. The UpdateKey parameter does not influence the efficiency of this method in Microsoft Dynamics NAV 2013.
  • FINDFIRST and Record.FINDLAST – The FINDFIRST and FINDLAST functions are optimized for finding the single first or last record within the specified filter and range. Use these functions when you only require one record.
  • FINDFIRST and Record.FINDLAST – The FINDFIRST and FINDLAST functions are optimized for finding the single first or last record within the specified filter and range. Use these functions when you only require one record.
  • FINDFIRST and Record.FINDLAST – The FINDFIRST and FINDLAST functions are optimized for finding the single first or last record within the specified filter and range. Use these functions when you only require one record.
  • FINDFIRST and Record.FINDLAST – The FINDFIRST and FINDLAST functions are optimized for finding the single first or last record within the specified filter and range. Use these functions when you only require one record.
  • NEXT – The NEXT function can be called at any time. However, if Record.NEXT is not called as part of retrieving a continuous result set, then Microsoft Dynamics NAV calls a separate SQL statement in order to find the next record.
Locus IT Project Management Office
What’s it?