SQL Repository components include a localeSensitiveSorting property that controls how query results are sorted. If this property is set to true, query results are sorted using locale-sensitive String comparison (via java.text.Collator). Since most databases cannot handle sorting with multiple locales, setting this option to true also means that the repository will perform all sorting in memory. If localeSensitiveSorting is set to false (the default), database sorting (via ORDER BY) is used where applicable and Strings are compared using String.compareTo(). If database sorting is adequate for your purposes, leaving this property set to false will result in better performance. For more information, see the ATG Repository Guide.

 
loading table of contents...