Hi Puspraj, When enabled, the "Ignore Case" option converts field names to uppercase before querying. If there's any case difference in the field names, the database index may not function as expected, which causes the query to traverse the entire table to filter results. This can significantly impact performance.
By default ignore cases should be unchecked!! Thanks & Regards -- Deepak Dixit ofbiz.apache.org On Wed, Jun 5, 2024 at 3:44 PM Pushpraj Singh Jadoun < [email protected]> wrote: > Hello Nicolas, > > I tested it with the following configuration: > org.gradle.jvmargs=-Xms128m -Xmx8192m -XX:+CMSClassUnloadingEnabled > > Kind regards, > Pushpraj SIngh Jadoun > > On Wed, 5 Jun 2024 at 13:32, Nicolas Malin <[email protected]> > wrote: > >> Hello Pushpraj, >> >> How memory have you set at XMX value ? >> >> Nicolas >> >> Le 17/05/2024 à 17:08, Pushpraj Singh Jadoun a écrit : >> >> Hello all, >> >> I am facing an issue while fetching a large number of datasets (over 20 >> million records) from an entity. Specifically, I receive the following >> error: >> >> "Caused by: java.lang.OutOfMemoryError: GC overhead limit exceeded" >> >> >> This error occurs when I attempt to navigate to the last page using the >> entity engine search page in Webtools. I have attached a screenshot for you >> to look over. >> [image: image-18- (1).png] >> >> >> >> [image: MAIL.png] >> >> >> Has anyone experienced a similar issue or can you offer advice on >> resolving this? >> >> Kind regards, >> Pushpraj SIngh Jadoun >> >> >>
