Skip to main content
A
admindnax1
Participant
June 12, 2012
Question

Coldfusion 10 + .NET performance issues

  • June 12, 2012
  • 1 reply
  • 785 views

I have a .NET dll with several classes and I am using <cfobject> to access them

inside my coldfusion 10 enterprise based website.  The dll is available localy in the webserver and I am able to access it with no problem but the performance is just horrible when I use any function that involves database access.

I am returning a DataTable and then I assign it to a variable

<cfset results = objectinstance.CurrentCUstomers()> I then display it using <cfloop query="results">. 

It works but it takes up to 20 seconds.  Is ridiculous.

What am I doing wrong?  Is there any configurations in the Administrator that I have to set?  Any special location were I should place the dll?  Actually, loading the object is super fast.  Is at the moment when I call the function that everything stalls.

I will appreciate any help.  Thanks

    This topic has been closed for replies.

    1 reply

    D
    Dan_Bracuk
    Inspiring
    June 12, 2012

    There is not enough information and therefore too many possibilities.  It could be the query that is slow, or transferring the data from the db to .net to cf, or it could just be rendering the output.

    Has this function run more quickly under other situations?

    A
    admindnax1Author
    Participant
    June 13, 2012

    Hi Dan. 

    Thank you for your time.

    I just finished creating an ASP.NET page to run the same class an it does it really fast.

    Is there any configurations on the Coldfusion Administrator that affect the performance

    of using a .NET object?   Do the dll's need to be registered with coldfusion or something?

    As I told you, I am accessing them locally and with asp it's working very fast.

    Any ideas?

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