API tools faq
paste
Advertisement
arsenische

comparison of distribution algorithms

arsenische
Jul 28th, 2011
420
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.88 KB | None | 0 0
raw download clone embed print report
  1. The following query will be executed 100000 times:
  2.  
  3. SELECT MemberId, fromWallet FROM bpMember ORDER BY (fromWallet+1)*rand() DESC LIMIT 1
  4.  
  5. And here are the results:
  6.  
  7. #255 deposited 5 and has been chosen 54170 times
  8. #276 deposited 3 and has been chosen 13930 times
  9. #40 deposited 2.95 and has been chosen 13052 times
  10. #228 deposited 2.51 and has been chosen 5602 times
  11. #158 deposited 2.5 and has been chosen 5551 times
  12. #73 deposited 2.46 and has been chosen 5016 times
  13. #72 deposited 2.1 and has been chosen 1648 times
  14. #254 deposited 1.816 and has been chosen 478 times
  15. #50 deposited 1.73 and has been chosen 306 times
  16. #160 deposited 1.5 and has been chosen 79 times
  17. #91 deposited 1.5000001 and has been chosen 67 times
  18. #80 deposited 1.48 and has been chosen 54 times
  19. #68 deposited 1.4 and has been chosen 30 times
  20. #69 deposited 1.235 and has been chosen 8 times
  21. #289 deposited 1.3 and has been chosen 4 times
  22. #273 deposited 1.2 and has been chosen 3 times
  23. #199 deposited 1.276 and has been chosen 2 times
  24.  
  25. The following query will be executed 100000 times:
  26.  
  27. SELECT MemberId, fromWallet FROM bpMember ORDER BY rand()*5/(1+fromWallet) limit 1
  28.  
  29. And here are the results:
  30.  
  31. #255 deposited 5 and has been chosen 9811 times
  32. #276 deposited 3 and has been chosen 5536 times
  33. #40 deposited 2.95 and has been chosen 5529 times
  34. #158 deposited 2.5 and has been chosen 4731 times
  35. #73 deposited 2.46 and has been chosen 4694 times
  36. #228 deposited 2.51 and has been chosen 4692 times
  37. #72 deposited 2.1 and has been chosen 3858 times
  38. #254 deposited 1.816 and has been chosen 3265 times
  39. #50 deposited 1.73 and has been chosen 3114 times
  40. #160 deposited 1.5 and has been chosen 2753 times
  41. #91 deposited 1.5000001 and has been chosen 2746 times
  42. #80 deposited 1.48 and has been chosen 2708 times
  43. #68 deposited 1.4 and has been chosen 2515 times
  44. #289 deposited 1.3 and has been chosen 2353 times
  45. #199 deposited 1.276 and has been chosen 2336 times
  46. #273 deposited 1.2 and has been chosen 2220 times
  47. #69 deposited 1.235 and has been chosen 2217 times
  48. #198 deposited 1.1 and has been chosen 2044 times
  49. #242 deposited 1.11 and has been chosen 1919 times
  50. #11 deposited 1.0545 and has been chosen 1903 times
  51. #29 deposited 1.03 and has been chosen 1861 times
  52. #281 deposited 1 and has been chosen 1795 times
  53. #203 deposited 1 and has been chosen 1780 times
  54. #88 deposited 1 and has been chosen 1747 times
  55. #159 deposited 0.925 and has been chosen 1733 times
  56. #1 deposited 0.82 and has been chosen 1470 times
  57. #15 deposited 0.78 and has been chosen 1429 times
  58. #17 deposited 0.79416126 and has been chosen 1395 times
  59. #33 deposited 0.7 and has been chosen 1297 times
  60. #7 deposited 0.7025 and has been chosen 1255 times
  61. #290 deposited 0.65 and has been chosen 1203 times
  62. #258 deposited 0.5 and has been chosen 915 times
  63. #44 deposited 0.5 and has been chosen 899 times
  64. #257 deposited 0.5 and has been chosen 890 times
  65. #166 deposited 0.5 and has been chosen 884 times
  66. #22 deposited 0.44301668 and has been chosen 793 times
  67. #49 deposited 0.43 and has been chosen 758 times
  68. #66 deposited 0.43 and has been chosen 733 times
  69. #2 deposited 0.3425 and has been chosen 646 times
  70. #184 deposited 0.35 and has been chosen 628 times
  71. #122 deposited 0.3 and has been chosen 523 times
  72. #173 deposited 0.31 and has been chosen 506 times
  73. #36 deposited 0.28 and has been chosen 496 times
  74. #3 deposited 0.25 and has been chosen 450 times
  75. #55 deposited 0.25 and has been chosen 432 times
  76. #21 deposited 0.2 and has been chosen 333 times
  77. #53 deposited 0.12532031 and has been chosen 224 times
  78. #230 deposited 0.12 and has been chosen 204 times
  79. #14 deposited 0.1 and has been chosen 194 times
  80. #287 deposited 0.1 and has been chosen 188 times
  81. #12 deposited 0.1 and has been chosen 184 times
  82. #288 deposited 0.1 and has been chosen 183 times
  83. #239 deposited 0.1 and has been chosen 182 times
  84. #204 deposited 0.1 and has been chosen 170 times
  85. #70 deposited 0.1 and has been chosen 158 times
  86. #294 deposited 0.067 and has been chosen 98 times
  87. #161 deposited 0.05 and has been chosen 83 times
  88. #282 deposited 0.03597761 and has been chosen 54 times
  89. #38 deposited 0.021 and has been chosen 40 times
  90. #194 deposited 0.02 and has been chosen 38 times
  91. #169 deposited 0.03 and has been chosen 36 times
  92. #19 deposited 0.02 and has been chosen 32 times
  93. #297 deposited 0.0105 and has been chosen 19 times
  94. #256 deposited 0.01 and has been chosen 19 times
  95. #16 deposited 0.0145 and has been chosen 18 times
  96. #269 deposited 0.01 and has been chosen 18 times
  97. #293 deposited 0.01 and has been chosen 17 times
  98. #42 deposited 0.01 and has been chosen 15 times
  99. #244 deposited 0.01 and has been chosen 13 times
  100. #249 deposited 0.009 and has been chosen 10 times
  101. #13 deposited 0.0045 and has been chosen 3 times
  102. #165 deposited 0.001 and has been chosen 3 times
  103. #30 deposited 0.0007 and has been chosen 2 times
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!