Skip to Content

Facing performance issue with SAP HANA Database Client

Jan 25, 2017 at 07:56 AM


avatar image
Former Member

I'm using SAP HANA Database Client with Code first approach of Entity Framework. Getting slow response on first connection to database and response time less on second time call.

Please let me know resolution to optimize SAP Hana database response to application.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Marco Simoncelli Feb 27, 2017 at 04:34 PM

Hi Jawed,

As far as I know, when DBContext is created for the first time in the application, it needs to create the model in memory, check for consistence and eventually check if the DB structure corresponds with the model.

The model is then stored at the AppDomain level so until the AppDomain is alive and DBContext is created and disposed under the same AppDomain it takes no time to be created.

May you give more details? Is your application running on a connected client or on a web server?

Kind Regards.

Marco Simoncelli.

10 |10000 characters needed characters left characters exceeded