Fixed
Details
Assignee
Zac SpitzerZac SpitzerReporter
Zac SpitzerZac SpitzerLabels
New Issue warning screen
Before you create a new Issue, please post to the mailing list first https://dev.lucee.org
Once the issue has been verified, one of the Lucee team will ask you to file an issue
Sprint
NoneFix versions
Priority
New
Details
Details
Assignee
Zac Spitzer
Zac SpitzerReporter
Zac Spitzer
Zac SpitzerLabels
New Issue warning screen
Before you create a new Issue, please post to the mailing list first https://dev.lucee.org
Once the issue has been verified, one of the Lucee team will ask you to file an issue
Sprint
None
Fix versions
Priority
Created 19 November 2024 at 15:04
Updated 6 January 2025 at 17:08
Resolved 6 January 2025 at 17:08
QoQ with HSQLB creates a view to determine which source columns are used for a query.
This is an optimization for working with larger source queries to avoid loading unused columns into the temporary database used for executing the QoQ.
This involves creating a view and reading the view metadata, which adds some overhead.
This can be cached, using the actual sql and create table sql as a key (column types in lucee queries can change as data is added https://luceeserver.atlassian.net/issues/LDEV-4564 )
Goal is to address the performance regression as seen on testlab