Out of sort memory

I am trying to sort a table according to the system created date column.
However, I get the following error : “Out of sort memory, consider increasing server sort buffer size”.
I have recorded fairly large JSONs in that table, but there are only 9 rows in that table, so I find this strange because the content is not need to sort.

How large are the JSON documents stored in the database?

I haven’t surveyed them all, but they go to a few tens of kB. Perhaps 50-80 kB I would say.

Please share steps to reproduce the issue in your app (app ID, table name, query, etc)

Sure :
App ID : D7075715-5086-625A-FFAB-39C2F40FB200
Table name : Feedbacks
Query : nothing special, I just go to the Data Browser view, and then click on the “created” column header like so :

I see that some JSON values exceed 100k. It is recommended to keep the JSON values under 10k, otherwise, store the JSON data as files.

1 Like