Additional system properties in the CSV export process for created tables

Masaaki Taguchi
Tera Contributor

Added system property "glide.ui.export.limit" because the CSV export exceeds 10000 lines.
We have seen that this has an impact on performance.
Should I remove this property after the work?
Or should I change the value (e.g. 10000)?

1 ACCEPTED SOLUTION

Community Alums
Not applicable

Hi @Masaaki Taguchi ,

Default Value is :

glide.ui.export.limit :10,000

The platform provides a default upper limit for data exports.

The purpose of the upper limit is to avoid creating performance issues when a table is excessively large. If you must export more records than the threshold permits, Break up a large export into separate manageable chunks.

In cases where you absolutely need to export a large chunk of data at once, you can create a system property to increase the limit:

  1. Enter sys_properties.list into the filter text field.
  2. Click New.
  3. In the Name field, enter glide.ui.export.limit.
  4. For type, select integer.
  5. In the Value field, enter <new amount>.
  6. Click Submit.

You can now export all of your records (for this one, the limit was increased to 20000):

image

Mark my answer correct & Helpful, if Applicable.

Thanks,
Sandeep

View solution in original post

8 REPLIES 8

Community Alums
Not applicable

Hi @Masaaki Taguchi ,

Default Value is :

glide.ui.export.limit :10,000

The platform provides a default upper limit for data exports.

The purpose of the upper limit is to avoid creating performance issues when a table is excessively large. If you must export more records than the threshold permits, Break up a large export into separate manageable chunks.

In cases where you absolutely need to export a large chunk of data at once, you can create a system property to increase the limit:

  1. Enter sys_properties.list into the filter text field.
  2. Click New.
  3. In the Name field, enter glide.ui.export.limit.
  4. For type, select integer.
  5. In the Value field, enter <new amount>.
  6. Click Submit.

You can now export all of your records (for this one, the limit was increased to 20000):

image

Mark my answer correct & Helpful, if Applicable.

Thanks,
Sandeep

After the export, should it be deleted or should the value be set to 10000?

Community Alums
Not applicable

Best Practice is to use the default Values and if you have large chunks then break it.

if you are changing the value then revert it back to default value.

Glad to see my answer helped you, Kindly mark the answer as Correct & Helpful both such that others can get help.

Thanks,
Sandeep

Thanks!

Sorry for my poor English.