Show Ads
 Refresh   About   Tools 

SQLite ORDER BY RANDOM() Randomosity Tester

+1 +10 +100 +1K +10K +MAX
range: 1-100, data points: 42,574, groups: 57
High / Low / Range / Average
Frequency: 475 / 365 / 110 / 425.74
Rows: 4 / 1 / 3 / 1.75
Frequency
Rows
475
1
474
1
465
1
461
3
458
1
457
1
454
1
453
1
451
1
450
1
448
3
447
1
445
3
444
1
442
2
440
1
439
2
438
1
437
3
436
4
435
3
434
1
433
1
432
2
431
1
430
2
429
2
428
1
427
1
426
2
425
3
424
2
423
1
422
3
421
1
420
4
419
1
418
2
417
3
416
3
415
2
414
1
413
2
412
1
411
3
409
2
407
1
406
3
403
2
397
1
394
2
393
2
390
1
387
1
385
2
383
1
365
1

Test runs: 0Avg run : 0 seconds Test time: 0 seconds Data Save: 0 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

Show Ads