When data is transferred between two tables, RapidiOnline works through the records byin the order they are returned from the source database server. After reading a record from the source table, RapidiOnline will normally (depending on the functionality selected) make a lookup in the

destination table using the table’sTable primaryLink key as sorting criteria.

If the field(s) specified in the "Table Link" window is not the primary key field(s) of the table(s) chosen, you can by using the feature "Sorting Destination Table" decrease the total transfer time noticeably. In the Sorting window you simply specify the non-primary key field(s) that should be used as sorting criteria instead.specified.

In some cases you can optimize performance by selecting a specific sorting. This is specifically true if you are using MS Dynamics NAV with a native database - here the sorting will be used to select a key and selecting a key that contains the fields used in the Table Link or in Delimitation is very important for MS Dynamics NAV native database.

If running on a SQL based system, the sorting will translate into an "Order By" in the select statement.

When using the Source Control feature, RapidiOnline automatically sets the sorting to the field used as Source Control and you should not specify Sorting Source Table in this case.

Field:

Here you specify the field(s), you want your data to be sorted by. If you need data sorted by more than one field, enter these on seperate lines.