Question

8
Replies
81
Views
Close popover
Kévin Giulietti (KévinG49)
Sopra Steria Group

Sopra Steria Group
FR
KévinG49 Member since 2019 8 posts
Sopra Steria Group
Posted: August 2, 2019
Last activity: August 6, 2019
Closed
Solved

Cost performance of unoptimized property vs optimized with DataType modification

Hello dear Community,

I'm using Pega 7.3/7.4 and I have a question considering property stored in DataBase.

the context : I need to get a property through a report. This property references the base 64 code to display an pdf and is natively unoptimized. The thing is that this property can contain a very long string (like a length of 270,000 characters). But if I optimize this property, the DataType in DataBase will be in VARCHAR(32).

So here are my few questions :

- Is it possible to optimize a property and then change its Datatype to something able to contain all the information ?

- If it is possible, does changing the datatype deoptimize my property ?

- Finally, what what will be more expensive in term of perfomance : an unoptimized property in the BLOB or an optimized property but with a modifier DataType ?

Best regards,

Kevin.

***Edited by Moderator Marissa to update platform capability tags****

Data Integration
Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.