Hi Outsystems Community,
I got some confuse when doing the exam test for the question below. The answer is B (Please refer to the first image).
However, As I read from document of Outsystems (Please refer to second image). If B is correct answer. The description field should be as a binary attribute instead of text attribute.
Please correct me if I'm wrong.
Thank you!
Hi,
B is the right answer, given the 4 answers.
Regards,
Daniel
ah, I see, so the best solution given in 4 answer is B. But the best practice is description filed as should be isolate in an extension entity with an 1-1 relation and description filed should be as binary attribute, right?
I corrected my answer B is good. The other part I wrote was rubbish and I removed it.
Hey!
I believe this has to do with performance and optimization.
If your text attribute has less than 2000 will be created as a varchar. But even for queries, having heavy attributes like this, that contain a lots of data, may lead to poor performance when querying the table.
Longs texts usually they refer to descriptions for example and most of the times they are not used for search, only to be visible on the details of a record.
The recommendation is, everything that is heavy should be saved in a 1-1 relationship on a different table.
Hi @Cuong Su,
The Answer B is correct
Why ?:
due to Performance Top 10 Rules described by outsytems.
https://success.outsystems.com/documentation/best_practices/performance_and_monitoring/performance_top_10_rules/#:~:text=Isolate%20large%20text,are%20strictly%20necessary.
Here is clearly mentioned
As a rule, Avoid the use of 2000+ characters in a text field if required then isolate that into binary and/or large text fields in separate entities and only retrieve them when they are strictly necessary.
Hope my answer will clear your confusion.
Kind regards,
Sanjay Kushwah
Hi Sanjay,
So the main thing is just isolate the text with more than 2000+ characters into 1-1 relationship. The field attribute either text or binary is also fine, right?
Correct it means,
case1:
If your Field length is more than 2000+ character then keep it into seprate entity into 1-1 relationship.
case2:
If your Field is Binary data type then also keep it into seprate entity into 1-1 relationship.
case3:
If in your master entity you have both attribute one attribute(e.g attribute1) with 2000+ character and one attribute(e.g attribute2 ) have Binary data type then Keep both attribute (attribute1 + attribute2) into seprate entity into 1-1 relationship with your master entity.
Hope now you got it clear.
thanks,
I got it, thank you
appreciate for your help