syscomments

RocketScientist's Miscellaneous Ramblings
posts - 76, comments - 354, trackbacks - 3

December 2007 Blog Posts

Thoughts on Query Complexity

I'm working with a vendor's system that has a very severe performance problem.  I'm looking at it because despite the fact that I told the vendor there was a problem with a particular query back in OCTOBER and that the problem was going to degrade linearly with the data size they didn't (1) fix the query or (2) provide us with a data archive system, and now it's an emergency. Sigh.  The reason the query is performing badly is that it's a query of a view.  Not a stored procedure containing a query of a view even, but their application directly...

posted @ Friday, December 28, 2007 4:56 PM | Feedback (2) |

Powered by:
Powered By Subtext Powered By ASP.NET