Fluid Pages are Slower than Classic Pages when Data is Contained in Spell Check System Dictionary. (Doc ID 2052752.1)

Last updated on JANUARY 26, 2024

Applies to:

Symptoms

Fluid pages are comparatively much slower than classic page. Performance is slower loading the pages when data is in the Spell Check System Dictionary.
Tracesql files from Fluid pages shows this SQL statement taking 18 seconds to return 20K rows.

SELECT SCOPRID, SCLANG, SCWORD, SCNEGWORDFLG FROM PSSCWORDDEFN ORDER BY SCOPRID, SCLANG, SCWORD

The SQL statement contains no WHERE clause and therefore no ability to use Indexes.
Truncating the record and reloading the data does not improve the performance.
The slowdown is unacceptable and customer is looking for a way to optimize performance.

Issue was originally replicated on HCM 9.2 PI 12 PT8.54.07.

Steps:
1.  Insert 20K rows into the record PSSCWORDDEFN
2.  Login to environment in Fluid mode > Manager Self Service > click any tile such as Company Directory
   Wait 18 seconds for load of page
3. Login to environment in Classic mode > click Company Directory
   Wait 14 seconds for load of page
4.  Delete all 20K rows from PSSCWORDDEFN
5.  Results:  login using Fluid mode > Manager Self Service > loads in 4 seconds
6.  Results:  login using Classic mode > click Company Directory > loads in 6 seconds

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.