SortTable

Article summary

Did you find this summary helpful?

Thank you for your feedback

Sorts a small table, based on a sort key.

Limitations

This method is only suitable for tables where the sort key and the biggest field can be loaded into memory
Generally this works out at around 500m records on a server with 64BG RAM

Key	Value(s)	Description
method	"SortTable"	Sorts a small table, based on a sort key.
table	"TableName"	Name of table to sort
sortKey	"ShortFieldName"	Short name of key to sort by. Sort will be ascending.
project	"CurrentProjectName"	Name of current project

{Explanation}

{
  "method": "SortTable",
  "table": "constructor%DSTAMP%",
  "sortKey": "sortkey",
  "project": "SmallTrans"
}

Was this article helpful?