Skip to main content
J
jqcf
Known Participant
May 25, 2009
Question

Loading Read Only Data from Database into CF Variable

  • May 25, 2009
  • 2 replies
  • 512 views

I'd like to load a large amount of data from a database into a Coldfusion variable so that it can be accessed later without hitting sql server at all.  I'm not sure how to begin this task.  Any pointers?         

    This topic has been closed for replies.

    2 replies

    M
    mack_
    Participating Frequently
    May 26, 2009

    +1 on what Dan said.

    I usually find that this premature optimization usually hurts

    performance. Have a sound database design, tune your database

    (indexes, etc) and check where the bottleneck is after that.

    Mack

    D
    Dan_Bracuk
    Inspiring
    May 25, 2009

    Start with cfquery.

    If you bring back too much data you are going to have performance issues.  What's wrong with just getting what you need when you need it?

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices