Caching Repetitive UDF Access to Request Scope Using Argument Stringified+Hashed Key

This page summarizes the projects mentioned and recommended in the original post on dev.to

InfluxDB - Power Real-Time Data Analytics at Scale
Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
www.influxdata.com
featured
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com
featured
  • qb

    Fluent Query Builder for CFML (by coldbox-modules)

  • While viewing FusionReactor logs for a ColdFusion app, I noticed lots of repetitive JDBC entries in a request that contained the same exact SQL statement and was taking 42ms per execution. I checked the UDF that was performing the query (using QB) and the query was configured to be cached for 5 minutes... but overhead-wise, it was still taking 42ms each time. The "Number of Queries" for the request was 57 and most of the queries were similar cached 40ms lookups and it started adding up to 1,452ms overall. I wondered if there was anything I could do to add self-contained caching to UDFs that could benefit from them. I didn't want to save the response to the session (YIKES! I've seen some code that does this) or use cachePut/cacheGet since the caching only needs to live for a single request of "repetitive access".

  • InfluxDB

    Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

    InfluxDB logo
NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts

  • Coldfusion Forum

    2 projects | /r/coldfusion | 23 Mar 2023
  • How to Get the Version of Any Java Package from CFML

    1 project | dev.to | 21 Sep 2022
  • CFDump ShowUDFs Behavior

    1 project | dev.to | 5 Apr 2022
  • What's built on Cardano today, September 20 2021. Explore the interactive version at https://builtoncardano.com and navigate to /art to find the full size image posted here.

    1 project | /r/cardano | 20 Sep 2021
  • Code Scanning for ColdFusion

    2 projects | /r/coldfusion | 19 Jul 2021