Database optimization confusion

Ilker Bekmezci

Solved

Question

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?

09 Nov 2017

José Costa

Solution

Hi Iker,

Yes. OutSystems will do:

SELECT B, D
FROM...

Cheers,

José

09 Nov 2017

Hitesh Maran

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-

09 Nov 2017

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.

See the full guidelines