I'm having a hard time figuring out where this SQL query came from. It's only used in production on Azure, and it's done in massive quantities (about 30-60k per hour) regardless of traffic. I was able to reduce it slightly (from 1.4 million per day to 0.4-0.8 million per day) by rebuilding indexes, but I'm not sure why. Zolaxis Patcher
hard time figuring out where this SQL query
I'm having a hard time figuring out where this SQL query came from. It's only used in production on Azure, and it's done in massive quantities (about 30-60k per hour) regardless of traffic. I was able to reduce it slightly (from 1.4 million per day to 0.4-0.8 million per day) by rebuilding indexes, but I'm not sure why. Zolaxis Patcher
is working on a reply...