December 09, 2005
Blog has been moved
This post has been moved to blogspot. No further posts will be made to this location.
Best Advice EVER!
I just couldn't help but laughing when I saw this solution to a problem. Okay, we're running out of "cursors" (ie. because we are not managing them properly). Instead of looking into this leak, just make the max # bigger... sooo smart. *cough*
This kind of crap is what gives software people a bad name. :-(
Posted by jim at December 9, 2005 03:25 PM
It's obvious that he knew that he was running out, and that it was set to 255. He probably already knew how to change it, since he knew what it was set to. This is just the kind of answers you get out of people who weren't trained very well. There's a lot of people who don't really know that much, but passed some certification course, and can spout off about various technologies, but not really know what they are talking about.
Anyway, to properly answer this question, you'd need a lot more information. Like how many users/queries are running on this thing. Without that simple amount of information, you can't possibly know whether 255 cursors is enough, and whether or not to even bother looking for ways to cut down on usage of cursors, or whether you should just increase the max.
Due to the proliferation of comment spam, Iíve had to close comments on this entry. If you would like to leave comment, please use one of my recent entries. Thank you and sorry for any inconvience caused.