Authentication Issue RRS feed

  • Question

  • Hi,

    I am facing one strange issue on sharepoint 2007 site. The site is authenticated by forms based authentication using membership provider framework.

    Each of the authenticated page of currently is calling the stored procedure aspnet_UsersInRoles_GetRolesForUser multiple times. it gives call to database around 20 times on each page. I have already checked through the code which i used there is nothing which i am referring externally which is calling this stored procedure. Even static web part page is also calling this page 8-10 times. Below is the some configuration of my system.

    I have also tried to cache it by using web.config cache setting but still the problem is same.

    - Windows server 2008R2, Sharepoint server 2007, IIS 6 , Sql server 2008, Dot net framework 2.0

    I want to stop sending multiple calls to database as it is increasing traffic and decreasing sql server performance.

    Please suggest.



    Thursday, January 10, 2013 5:00 PM