Skip to Content
0
Former Member
May 29, 2008 at 01:07 PM

Performance ?

77 Views

I have some Business Logic that takes approximately 2 seconds to run. I determined this by adding logging blocks to the beginning and end of the transaction. When I execute the query template it takes 15 seconds to return the data. The data returned is xml, has 13 rows and 16 columns. I having a hard time understanding why this query is taking so long to complete. No other queries that I have are taking this long. Is there some initialization or cleanup that is being done that is using up this time ?

Any help would be appreciated.

Thanks

Edited by: Glenn Doherty on May 29, 2008 3:08 PM