Hide Ads
 Refresh   About   Tools 

SQLite ORDER BY RANDOM() Randomosity Tester

TIMEOUT
+86 data
+1 +10 +100 +1K +10K +MAX
range: 1-10,000, data points: 454,950, groups: 50
High / Low / Range / Average
Frequency: 73 / 21 / 52 / 45.50
Rows: 623 / 1 / 622 / 200.00
Frequency
Rows
73
2
70
2
69
2
68
2
67
7
66
10
65
16
64
9
63
25
62
36
61
42
60
63
59
83
58
115
57
136
56
185
55
190
54
262
53
282
52
346
51
431
50
437
49
499
48
548
47
553
46
623
45
590
44
576
43
565
42
559
41
491
40
448
39
396
38
322
37
293
36
221
35
192
34
114
33
118
32
68
31
63
30
33
29
15
28
17
27
5
26
4
25
1
24
1
22
1
21
1

Test runs: 87Avg run : 0.016028 seconds Test time: 1.394414 seconds Data Save: 0.021035 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