Performance Regressions since 6.2.0

APTrevor · November 5, 2025, 11:59pm

We went from 6.2.0.321 to 6.2.3.35 and saw a huge decrease in performance. Downgraded this morning back to 6.2.0.321 and all is back to normal. We also are testing with 6.2.2.91 and seeing the same performance issues.

Zackster · November 6, 2025, 10:34am

specifically with database performance?

can you go into a bit more detail? if we can reproduce it, we can fix it

This is our db microbenchmark on testlab results running 25k

github.com

lucee/lucee-testlab/blob/main/custom/benchmark/tests/db.cfm

<cfscript>
	params = {
		test: {value: createUUID(), sqltype="varchar" }
	};

	query params=params result="result" datasource="mysql" {
		echo( "INSERT INTO benchmark( test ) VALUES ( :test )" );
	}
	params.id = { value: result.generatedKey, sqltype="numeric" };

	query name="q" params=params datasource="mysql" {
		echo( "select id, test from benchmark where test = :test and id = :id " );
	}

	if ( q.id != params.id.value || q.test != params.test.value || q.recordcount !=1 )
		throw "invalid result [#params.toJson()#], [#q.toJson()#]";

</cfscript>

APTrevor · November 6, 2025, 1:08pm

We are doing more testing but we do not think its database related. If we look in Fusion Reactor and see the slow requests, it is the code rendering that is slow. The JBDC responses on these slow requests are super fast

Zackster · November 6, 2025, 3:59pm

ok, I’ve split this out into a separate thread if it’s not db related

Can you provide some examples?

is it also slow without the FR agent?