Query each slow (Lucee 6.2.)

[michaeldiederich]

I upgraded my local stack to lucee 6.2.2 / jdk 21 / tomcat 11.

I have a small script, uploading a csv file (6 columns), parse each data field (e.g. validate) and then i collect the rows in an array. If the array length is 100, I create one “INSERT INTO” sql statement with 100 rows.
The file has 363 rows, really nothing special and this works within less seconds.

After the upgrade, the script ran in a timeout and the Query each-function is terrible slow:

The Lucee web admin also shows a lot of implicit variable access - not sure if this is related:

I switched from 100 data rows to 10 rows, makes it much faster:

This feels like a bug?

[michaeldiederich]

Here’s a small test case that reproduces the bug.
To get it running, create the test table (first comment) and change the datasource (line 14). I hope this helps.

query each slow.cfm (2.4 KB)

[michaeldiederich]

One more update: Lucee 6.1.1.118 on old hardware, same csv file as in my first posting:

[Zackster]

Does it happen with CF loop too?

I’m on my phone at the beach, you’re using queryExecute based on the helperBase.cfc, plain old cfquery should be fine tho

Obviously this seems to be a regression