Show Ads
 Refresh   About   Tools 

SQLite ORDER BY RANDOM() Randomosity Tester

TIMEOUT
+150 data
+1 +10 +100 +1K +10K +MAX
range: 1-10,000, data points: 1,712,663, groups: 94
High / Low / Range / Average
Frequency: 237 / 126 / 111 / 171.27
Rows: 333 / 1 / 332 / 106.38
Frequency
Rows
237
1
228
1
221
1
220
1
219
1
218
1
216
1
215
2
214
1
213
2
212
1
211
5
210
9
209
5
208
11
207
10
206
8
205
11
204
9
203
11
202
21
201
26
200
23
199
36
198
33
197
41
196
46
195
59
194
69
193
84
192
76
191
97
190
106
189
112
188
141
187
164
186
130
185
174
184
209
183
197
182
208
181
230
180
242
179
221
178
288
177
263
176
275
175
275
174
270
173
292
172
303
171
325
170
287
169
333
168
313
167
326
166
305
165
272
164
244
163
259
162
252
161
237
160
225
159
229
158
185
157
163
156
173
155
143
154
119
153
112
152
102
151
90
150
83
149
73
148
61
147
49
146
39
145
34
144
28
143
27
142
26
141
16
140
12
139
11
138
11
137
3
136
5
135
12
134
2
133
5
132
2
129
2
128
1
126
1

Test runs: 151Avg run : 0.009310 seconds Test time: 1.405862 seconds Data Save: 0.015334 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

Show Ads