Skip to main content
A
Aegis_Kleais
Inspiring
October 30, 2012
Question

Fast Query, LONG time to output

  • October 30, 2012
  • 2 replies
  • 740 views

I am running a query and doing a dump with an abort.  Even utilizing the cachedwithin (set to 4 hours), the page takes a good 30-40 seconds to load before the dump is shown to the screen.  The query returned 164 records and says the execution time was 125ms.

My question is, How can I determine what took the other 39,875ms?

    This topic has been closed for replies.

    2 replies

    D
    Dan_Bracuk
    Inspiring
    October 30, 2012

    The rest of the time was spent by the browser rendering the html sent to it.  If you had metainfo="yes", not only does the browser have to render the query results, it also has to render the sql and all the parameters.  If you had debugging turned on, that's more information to be rendered.

    A
    Aegis_KleaisAuthor
    Inspiring
    October 30, 2012

    Good catches guys.

    I removed the dump and had it just output the recordcount, and the page loaded very quickly.

    I then trimmed up the SQL (They were using a SELECT *, so I chose just the fields needed).  Originally there were about 40 fields and 164 rows.  Now there are 8 fields and 164 records.

    I took a look at the code CF dumped and it's rather convoluted for such a simple table-based output.  Ugh.

    We're getting into the Error-Handling, Logging, Auditing and Debugging part of our framework, and I'm very keen on running things as optimal as possible. 

    As far as CF-based metrics, does only Enterprise/Developer offer such functionality or is there a built-in service that I can tie into that will let me monitor performance based values for CF?

    12Robots
    12Robots
    Participating Frequently
    October 30, 2012

    >>My question is, How can I determine what took the other 39,875ms?


    The dump. cfdump is slow, especially when output complex types (structs, xml, queries).  Try running the page without the dump. You'll see it loads quickly. Don't try to benchmark your page with a dump in it.

    Jason

    Carl Von Stetten
    Carl Von Stetten
    Legend
    October 30, 2012

    I agree with Jason on this.  But, just out of curiosity, how many columns are being returned in your query?  Forty seconds is not out of the question, especially if there are many columns.

    -Carl V.

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