Cfquery with cachedwithin woes. Also.. cfobjectcache filter issues

dev google-group-archive
1

I have an application I am moving from BD to lucee. However I am stuck in
a giant pitfall. For speed issues I cache many queries so I don’t have to
go to the database often. But I just can’t find a suitable solution here.

Issue 1: The cachedwithin attribute on cfquery tags does not allow for
uncaching when I use a #CreateTimeSpan(0, 0, 0, 0)#. I am unable to find a
easy way to uncache a specific query.

Issue 2: The filter attribute of does not seem to apply to
an action=“clear”.

The only workable solution I have found is to delete ALL cached queries by
doing

However, this forces EVERY query to uncache which is totally unecessary. I
would hope/expect for this to work, but it does not

Would appreciate input! To test this just change the first line to a valid
datasource.—

div.ex { border:1px solid black; margin:10px; background-color:yellow; width:500px; }

#selectQuery#

Result 1:

#selectQuery#

Result 2:

#selectQuery#

Result 3:

#selectQuery#

Result 4:

#selectQuery#

Result 5:
Result 6:

#selectQuery#

Result 7:
Result 8:
Can't show, but the object is cleared. Evidenced by the next query #9 below.

#selectQuery#

Result 9:
2

here is the relevant bug, i see you have already found it :slight_smile:
[LDEV-907] - Lucee Thu, Dec 29, 2016 at 7:25 AM, aree <@aree> wrote:

I have an application I am moving from BD to lucee. However I am stuck in
a giant pitfall. For speed issues I cache many queries so I don’t have to
go to the database often. But I just can’t find a suitable solution here.

Issue 1: The cachedwithin attribute on cfquery tags does not allow for
uncaching when I use a #CreateTimeSpan(0, 0, 0, 0)#. I am unable to find a
easy way to uncache a specific query.

Issue 2: The filter attribute of does not seem to apply to
an action=“clear”.

The only workable solution I have found is to delete ALL cached queries by
doing

However, this forces EVERY query to uncache which is totally unecessary.
I would hope/expect for this to work, but it does not

Would appreciate input! To test this just change the first line to a
valid datasource.

div.ex { border:1px solid black; margin:10px; background-color:yellow; width:500px; }

#selectQuery#

Result 1:

#selectQuery#

Result 2:

#selectQuery#

Result 3:

#
selectQuery#

Result 4:

#selectQuery#

Result 5:
Result 6:

#selectQuery#

Result 7:
Result 8:
Can't show, but the object is cleared. Evidenced by the next query #9 below.

#selectQuery#

Result 9:

–
You received this message because you are subscribed to the Google Groups
“Lucee” group.
To unsubscribe from this group and stop receiving emails from it, send an
email to lucee+unsubscribe@googlegroups.com.
To post to this group, send email to lucee@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/
msgid/lucee/9e6baf2c-4549-4a6d-a3ee-30dc001bbe38%40googlegroups.com
https://groups.google.com/d/msgid/lucee/9e6baf2c-4549-4a6d-a3ee-30dc001bbe38%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

–
Zac Spitzer
+61 405 847 168