Hide Ads
 Refresh   About   Tools 

SQLite ORDER BY RANDOM() Randomosity Tester

TIMEOUT
+28,375 data
+1 +10 +100 +1K +10K +MAX
range: 1-100, data points: 28,376, groups: 55
High / Low / Range / Average
Frequency: 321 / 235 / 86 / 283.76
Rows: 4 / 1 / 3 / 1.82
Frequency
Rows
321
1
320
1
319
2
315
2
313
1
312
2
310
1
308
1
307
1
306
1
304
2
303
1
302
1
301
1
299
1
298
2
297
1
296
1
295
1
294
4
292
3
291
4
289
1
288
1
287
2
286
4
285
2
284
3
283
4
282
2
281
2
280
3
279
3
278
2
277
1
276
4
275
1
274
1
273
3
272
2
271
4
270
2
269
3
268
1
267
1
265
1
264
2
263
2
261
1
259
1
253
1
252
1
247
2
246
1
235
1

Test runs: 28,376Avg run : 0.000050 seconds Test time: 1.419462 seconds Data Save: 0.011944 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 100.

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