Scope: managed applications, mobile applications, and ordinary applications.
When you sort a table by the columns that contain reference values, 1C:Enterprise will call the infobase to get the presentations of these references.
- When sorting by description is required, upon filling, add additional columns with presentations to the table, and sort exactly by them. Unless it causes similar multiple access to the infobase.
- In other cases, sort "by reference" rather than by a presentation. To do this, use the CompareValues object in the Sort method:
ObjectOfComparison = New CompareValues;
DocumentsTable.Sort ("Date,Ref", ObjectOfComparison);
This is especially important for tables with a large number of rows, in algorithms with critical run time.