Topic:  Performance, Large Texts, big strings should be saved a text file and be displayed it in the formula field

Short description: 
Very large amounts of text are often stored in RichText fields (log data, HTML code, Base64-encoded images).
Ninox stores all text data as plain text, e.g., HTML as code.
When dealing with large data objects stored in text fields, Ninox performs very slowly.
Therefore, in Ninox, you should always store such text in *.txt files.

The database provided here shows you what an automation for this scenario might look like in your Ninox solution:

1. Insert a very large text (e.g., a copied webpage) into the “Website” field in a record and see what happens. 
2. When you click the “Finish and Save” button, the database converts the entered text into a text file, saves it as a file attachment to the record, and then deletes the entry in the “Website” rich-text field. 
3. This way, these (very) large texts do not impact the performance of the Ninox solution, because the texts are not stored as field values in a text field.
4. The content of the attached text file is displayed in a formula field.

Search words: Big strings, Large text, email bodies, email body, base64, performance, improve performance, text file