The String Memory Gotcha (2005)

Thanks for noting. Edited the title to make it easier to see (I certainly missed this fact). Howerver, some points it makes are still current, specially about substring chains (which also apply to sub-collections). Most people who use profiles with memory profiling learn these things the hard way...

Seems this at least holds true for Oracle 11g, IBM DB2 10 and Microsoft SQL Server 2008. Of course, this post beeing from 2005 it was none of these versions, but you sort of get the idea :-)

Source: http://www.jpab.org/Microsoft/SQL/Server/2008/IBM/DB2/10.htm... (You can try with different databases.)

Shouldn't you take into account WHY they have restrictions?

Last time I looked at these kind of restrictions in databases or app servers (some of those have them too), it was clear that some of them were there to protect against the others.

Consider that when company X prohibits this, it immediately gives them an advantage over their competitors, as X can publish benchmarks showing that X is better than the competitors, and the competitors can't run counter benchmarks.

Because of this I've seen where company Y would then add restrictions, but they would not actually prohibit publishing, but rather would require that if company X publishes, the publication must include complete hardware and software configuration information to allow reproduction of the test, and X must grant Y permission to publish benchmark's of X's product on the same terms, regardless of any restriction in X's license.

I wonder about the legality of such licenses.

Practically every commercial SQL database prohibits publishing profiling data. It's customer hostile and it sucks but there you go. Use a free software licensed SQL database if you want to publish perf numbers.

Sometimes they do matter, but what I gruently had to realize is how few times this is the case (the blog post is a good example - plenty of people here had used Java extensively and never hit these issues).