Entity vs Static Entity - Performance

Is there any performance benefit for static entity over entity ?

Let us say,

  • If we have a Static Entity SampleOne and we execute below code GetSampleOne(Entities.SampleOne.ID).SampleOne.Label 

Is any query hit for this and if yes what will be a query ?


  • If we have a Entity SampleTwo and we execute below code GetSampleTwo(Entities.SampleTwo.ID).SampleTwo.Name

Is any query hit for this and if yes what will be a query ?



 

Solution

Hello Akshay

A Static Entity is actually an Entity.

Both will generate queries that will be executed in database.

The difference is not performance, that existing should be minimal, but utilization.

Cheers

Solution

Eduardo Jauch wrote:

Hello Akshay

A Static Entity is actually an Entity.

Both will generate queries that will be executed in database.

The difference is not performance, that existing should be minimal, but utilization.

Cheers

Thank you Eduardo.


Hi Eduardo,

I also concern about the performance of this. We are calling the DB each time we call the static entity right? Or OutSystems is managing the static entity on cache?

Could you please help me clarify?

Thanks,

Thang Nguyen

Hi, 

The static entity itself is not cached, I think. 

But the static entity Get method, according to OutSystems, is cached. 

Cheers