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