Database optimization confusion

Database optimization confusion

  

I need to clarify a concept in OutSystems Platform.

It is stated in OutSystems docs that Optimized database fields fetch ensures only data that is effectively used in the application is fetched from the database regardless what the developer coded.(ref : https://success.outsystems.com/Support/Enterprise_Customers/Maintenance_and_Operations/Database_optimization)

QUESTION: For example, if I write an aggregate that fetches fields A, B, C and D. But I only use B and D in my screen, will OutSystems sense that only B and D is needed and A and C will not be fetched.

Is this the way OutSystems do?

Hi Iker,

Yes. OutSystems will do:

SELECT B, D
FROM...

Cheers,

José

Hi lker,

Yes through Advance query you can fetches data from the database. you can write your own statements and get selected attributes value. Sample code are given below. 

SyntaxEditor Code Snippet

SELECT {User}.[Name],
{User}.[Email],
{User}.[MobilePhone]
from {User}


-Hitesh-