Does anyone know how I would be able to determine the Redis cache key Lucee generates for queries using CFML? I want to do some cache busting. I know about the query "tags" but when you have hundreds of thousands of Redis cache entries it is very slow since it will loop over every single entry in Redis. I looked at the source code of Lucee and have tried to replicate it but I can't seem to come up with a matching key it honestly isn't even close.

This would be the sort of thing that would be handy to return in the

result

variable of a query.

I agree it would be super helpful

It's a hash of query attributes, Params and sql

@zackster do you know where in the source code it is generated or do you have an example of CFML that can reproduce the hash?

thanks

do you want to be able to bust the cache for a specifc query?

Yes but the

tags

attribute on the query is very slow when there are hundreds of thousands of items in the cache

yeah, so go ahead and file a bug asking to include the cacheid in the result