Composite provider vs OpenDSO performances

[FCI]

Hi,

I built a query on a composite provider built itself on a Hana calculation view. The composite is directly built on the calculation view (only one provider) with no navigational attributes. All fields are assigned to infoObjects.

The Db execution time was 30s.

As I was not getting the expected performances (compared to the execution time of the calculation view), I built the same query on an open DSO built on the same calculation view. All fields are assigned to infoObjects.

The DB execution time was 3s.

What can explain this 10 times difference ?

There is nothing special done at the query level (no calculation), nothing special at the composite level (no nav. attributes, only one provider). I was expecting similar performances.

Regards,

Frédéric

[FCI]

Run a RSR_MULTIPROV_CHECK and a RSDDB_LOGINDEX_CREATE on the composite but with no avail.

[RolandKramer]

Hello cincet.frdric2

you should ask frank.riesner1 for that.best regards Roland