Session Data Storage Optimization

[Thananchseyan]

Is your suggestion related to an experience ? Please describe.

We are using IDN_AUTH_SESSION_STORE and IDN_AUTH_TEMP_SESSION_STORE for storing caches during the authentication flow. The java objects which are used by the IS are serialized and stored in these tables as BLOB data types. Usually these objects are heavy, so storing and retrieving this data in the database adds load to the database. This leads to major performance bottlenecks in the authentication flow.

Describe the improvement

Optimizing the session objects of the session data storage.

• Authentication Context Cache - Optimization Authentication Context Cache - Optimization  #14549

• Session Context Cache - Optimization Session Context Cache - Optimization  #14708

• Authentication Result Cache - Optimization

• Authorization Grant Cache - Optimization

• Authentication Request Cache - Optimization

• Session Data Cache - Optimization

• Authentication Error Cache - Optimization

• Long Wait Result Cache - Optimization

• OIDC session participants Cache - Optimization

Testing

• Testing with existing data
• Testing by changing the configurations

Documentation

• Adding about the Session Data Storage Optimization - Configuration Session Data Storage Optimization - Adding configuration  #14722

[areebniyas]

After evaluating the caches below it was noticed that they do not hold any bulk objects or attributes that would require an optimization effort:

• Authentication Result Cache
• Authorization Grant Cache
• Authentication Request Cache
• Authentication Error Cache
• Session Data Cache
• Long Wait Result Cache

[areebniyas]

For the OIDC Session Participant Cache, it was noticed that the size of the cache is low. So there wont be a noticeable optimization.

[senthalan]

Thank you @Thananchseyan @areebniyas for getting this critical improvement added to the product.