Hide Ads
 Refresh   About   Tools 

SQLite ORDER BY RANDOM() Randomosity Tester

TIMEOUT
+76 data
+1 +10 +100 +1K +10K +MAX
range: 1-5,000, data points: 362,714, groups: 59
High / Low / Range / Average
Frequency: 104 / 45 / 59 / 72.54
Rows: 233 / 1 / 232 / 84.75
Frequency
Rows
104
1
102
2
101
3
100
1
99
2
98
6
97
3
96
7
95
6
94
13
93
14
92
15
91
19
90
23
89
30
88
46
87
64
86
75
85
84
84
101
83
122
82
143
81
118
80
145
79
186
78
200
77
185
76
193
75
224
74
233
73
232
72
226
71
220
70
227
69
220
68
183
67
199
66
162
65
191
64
149
63
126
62
113
61
104
60
75
59
59
58
48
57
55
56
39
55
22
54
24
53
15
52
22
51
9
50
4
49
4
48
2
47
2
46
2
45
2

Test runs: 77Avg run : 0.018570 seconds Test time: 1.429872 seconds Data Save: 0.071793 seconds Test Tools: Restart test: Random range 1 to: 1 2 3 4 5 10 50 100 500 1K 5K 10K 50K 100K Random Generator Method: SQLite ORDER BY RANDOM() PHP rand() PHP mt_rand() PHP random_int() Back to top

About the Randomosity Tester

This page tests the frequency distribution and timing of random number generation via these methods:

Random number results are stored in a test table. The test table is defined as:

CREATE TABLE 'test' ( 'id' INTEGER PRIMARY KEY, 'frequency' INTEGER DEFAULT '0' );

The table is initialized by creating all rows with frequency = 0. The number of rows in the table is defined by the range setting. The current test is set to use range: 1 to 5,000.

For each random number chosen, the table is updated via:

UPDATE test SET frequency = frequency + 1 WHERE id = :random_number

For SQLite tests, results are individually generated via the SQL call:

SELECT id FROM test ORDER BY RANDOM() LIMIT 1;

Generate more random numbers by clicking a  +  number button to start a test run.

Each test run is limted to ~1.42 seconds.

A Frequency of Frequencies chart displays:

This site was created with Open Source software. Find out more on Github: randomosity-tester v0.2.2

Back to top


Hide Ads