Hide Ads
 Refresh   About   Tools 

SQLite ORDER BY RANDOM() Randomosity Tester

TIMEOUT
+222 data
+1 +10 +100 +1K +10K +MAX
range: 1-10,000, data points: 1,657,009, groups: 95
High / Low / Range / Average
Frequency: 217 / 115 / 102 / 165.70
Rows: 331 / 1 / 330 / 105.26
Frequency
Rows
217
1
213
1
212
1
211
2
210
1
209
3
208
4
207
2
206
4
205
3
204
6
203
9
202
16
201
6
200
10
199
14
198
21
197
10
196
22
195
31
194
30
193
26
192
41
191
48
190
62
189
82
188
77
187
77
186
86
185
75
184
91
183
120
182
128
181
145
180
166
179
192
178
190
177
214
176
215
175
253
174
231
173
246
172
286
171
291
170
265
169
286
168
268
167
310
166
331
165
303
164
302
163
302
162
287
161
298
160
266
159
246
158
273
157
283
156
239
155
227
154
224
153
204
152
178
151
182
150
156
149
127
148
117
147
120
146
81
145
110
144
88
143
52
142
62
141
48
140
31
139
43
138
27
137
28
136
20
135
16
134
15
133
13
132
5
131
8
130
3
129
2
128
1
127
4
126
2
125
2
124
2
123
1
120
1
118
1
115
1

Test runs: 223Avg run : 0.006354 seconds Test time: 1.416855 seconds Data Save: 0.066813 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 10,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