I have, at times in the past, advised people to try turning on document compression in their databases as a way to improve performance, thinking that if the application is I/O bound, the extra time spent in compressing/uncompressing the data, would be more than made up for by the time savings of not having to read as much data.
Apparently, though, the benchmarks show that it's a rare situation where this would work, and that using compression actually slows things down at least a percent or two in most cases. Windows and 8.5.2 has the best performance, but still not good enough to make trying this worthwhile.
Compression still does an excellent job of saving disk space, however!
Andre Guirard | 24 August 2010 11:12:04 AM ET | Home, Plymouth, MN, USA | Comments (1)
