I am facing a strange problem. I have query in a BOI DLL which normally takes 3-4 seconds to execute. But sometimes it takes 200-350 seconds to execute the same query. First BOI Call in the morning and after lunch. Sometimes in between too this query takes time.
any clues as to why query slows down drastically at times?
Thanks in Advance