Hi all,
I would like to send this extract from "show regions" command as it seems to be
inaccurate.
42 TREE1 1049661 0 13 0 0 0.00 %
43 TREE2 253041181 325869 1363778 1579 0 0.54 %
44 TREE3 40627069 4759 47605 335 0 0.12 %
45 TREE4 43695545 107869803 1169601857 77037 0 2676.71 %
46 TREE5 144138715 38837 243329 6390 0 0.17 %
47 TREE6 435790163 266147 2864588 191 0 0.66 %
48 TREE7 157445506 189785 1206941 2229 0 0.77 %
49 TREE8 1297063869 3230266 37091726 4713 0 2.86 %
Line for the region TREE4 states the collision rate which higher than 100% that should
not be right.
It was about 22-24% before.
The collision rate about 25% looks quite worring for me. Is there any way to improve
this other than decrease the load on the database server
(any configuration options, etc). Does this occur because intensive update of the
indexes?
The logic of the application that I run might with some extend be describes as a
sequence of the "SELECT_AND_INSERT_IF_NOT_EXISTS" operations that run concurrently
and I want to get the highest possible load on the database server that doesn't lead
to the performance degradation.
Thanks in advance.
Dmitry Lyssenko
Nuix Pty. Ltd.
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
