On Mon, 19 Mar 2012, Tibor Simko wrote: > BTW, you seem to have a limit of 200 for bib99x now. I think your URLs > may all fit well into 100, isn't it?
Here is how you can check what is the percentage of bib99x values that would be fitting into 35; an example for INSPIRE: mysql> SELECT COUNT(DISTINCT(SUBSTR(value,1,35)))/COUNT(DISTINCT(value)) FROM bib99x; +------------------------------------------------------------+ | COUNT(DISTINCT(SUBSTR(value,1,35)))/COUNT(DISTINCT(value)) | +------------------------------------------------------------+ | 0.9892 | +------------------------------------------------------------+ 1 row in set (36.51 sec) So indexing only 35 leading characters for INSPIRE site conditions nicely covers 98.9% of our reference values. Best regards -- Tibor Simko
