Coldfusion 10 + .NET performance issues

Report · Jun 12, 2012

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

Report · Jun 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?

Report · Jun 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?