Skip to main content
A
Anonymous
October 9, 2012
Question

.NET Service

  • October 9, 2012
  • 1 reply
  • 725 views

Hi All,

I am using a .NET dll through the CF 9 .NET Service to invoke a method that simply returns a DataTable which I then use in a CFQUERY to output to a table. It runs fine with smaller datasets but when I get to a few thousand it starts slowing down considerably to the tune of taking 2 minutes for a query. This same query is returned within a few seconds in SQL Server 2008 and using ASP.NET to invoke the dll it's easily handled in 20 seconds or less. It only returns 7 columns so there isn't a giant complex datatable or anything. I've been scouring the Web trying to find causes for this and possible solutions and can't find anything anywhere. It's a Windows Server 2008 R2 box running CF  9.0.1.

Thanks very much in advance for any help you can give.

Thanks!

Ed

This topic has been closed for replies.

1 reply

D
Dan_Bracuk
Inspiring
October 9, 2012

If you are outputting a few thousand rows of data, the delay is most likely caused by the browser rendering all that data.  Output some text and then do a cfflush before and after your relevent bits of code to see if this is the case.

Also, you say that you use the .net DataTable in a cfquery.  How exactly do you do that?

A
Anonymous
October 9, 2012

Thanks for the quick response Dan. I'm actually passing the datatable as the query parameter for the CFOUTPUT tag. Not in a CFQUERY persay. My fault for any confusion. I will try the CFFLUSH to see what's going on.

Ed

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