Skip to Content
author's profile photo Former Member
Former Member

Facing performance issue with SAP HANA Database Client

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.

Add comment
10|10000 characters needed characters exceeded

1 Answer

  • Posted on 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.

    Add comment
    10|10000 characters needed characters exceeded