Skip to main content
F
Florida
Known Participant
June 5, 2008
Question

Web Application performance tips

  • June 5, 2008
  • 1 reply
  • 255 views
If I am loading someone else's Cold Fusion MX7 (using Oracle) web app to my server I need to check for several things in my development environment before it is loaded to the production server.

Please advise if I am on right track?

1- I need to check Query lengths...if the Database updates and additions take a long time.

2- Showing large amounts of records where intially the web app has very few records and then after couple months it might have thousands of records. Basically how is it handling large amounts of records in display, searches and reports.

3- Is the web app draining resources from the Database it is using. And is it draining or bringing down JRUN.

Any other things to look for or anything I am wrong on?
    This topic has been closed for replies.

    1 reply

    D
    Dan_Bracuk
    Inspiring
    June 5, 2008
    My efficient coding tips include:

    When running select queries, only bring back the data you need.

    Scope all your variables (admittedly, I don't always practice this one)

    Use cfqueryparam unless there is a reason not to (and sometimes there will be)

    Do this:
    <cfoutput>
    <cfloop>
    instead of this
    <cfloop>
    <cfoutput>

    Get the server you perceive as less busy (database or coldfusion) to do the work if you are given a choice.

    Make use of frames or iframes if you don't have to change the entire page on a request.

    Either cache queries or make them session variables as appropriate.

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