Re: Tablespace size

On Feb 20, 12:41 pm, Obnoxio The Clown <obno...@serendipita.com> wrote: > Neil Truby wrote: > > > I'm surprised that you don't think it's important.  Less surprised at > > Obnoxio - I doubt if he ever really administers any proper systems, and his > > kitchen inventory system running on IDS 11 hasn't hit any limits yet ;-) > > Those words will come back to haunt you. > > -- > Cheers, > Obnoxio The Clown > > http://obotheclown.blogspot.com > > -- > This message has been scanned for viruses and > dangerous content by OpenProtect(http://www.openprotect.com), and is > believed to be clean. Guys - I agree with the "most honorable Mr. Truby" on this one. We see clients all the time hitting one of the 3 limits (pages, size, rows) that IDS still is enforcing. And no - it's not a trivial fix, regardless of what the limit might be. And IF the skill level is low- medium, then they typically shy away from it, even with a good explanation. We have a number of clients that choose to purge/delete rows when getting there or close, versus implementing a frag'd solution. We once discussed "automatically fragmenting" a partition if it was hitting one of the limits, but the feature didn't make it. That feature would have supported the "set it and forget it" much better for sure, but I believe the inherent ramifications outweigh the possibility (and issues that come with) of "set it and forget it." I also agree that advertising "set it and forget it" is simply misleading. WAY too many variables to say that one is available or rings of some percentage truth. In many clients cases, that's EXACTLY what happens, but in many (obviously) that is impossible (again, due to many variables, including education, staffing, etc...). HTH - Mark Scranton Xtivia Inc.