Show Ads
 Refresh   About   Tools 

SQLite ORDER BY RANDOM() Randomosity Tester

TIMEOUT
+232 data
+1 +10 +100 +1K +10K +MAX
range: 1-10,000, data points: 874,702, groups: 68
High / Low / Range / Average
Frequency: 123 / 53 / 70 / 87.47
Rows: 433 / 1 / 432 / 147.06
Frequency
Rows
123
1
121
1
120
2
119
4
118
1
117
5
116
7
115
5
114
5
113
14
112
20
111
21
110
20
109
29
108
40
107
44
106
63
105
67
104
88
103
103
102
133
101
154
100
144
99
224
98
241
97
253
96
274
95
314
94
356
93
323
92
372
91
406
90
374
89
393
88
417
87
433
86
425
85
397
84
405
83
385
82
375
81
356
80
283
79
304
78
285
77
239
76
208
75
157
74
164
73
134
72
120
71
100
70
82
69
62
68
52
67
29
66
22
65
19
64
15
63
6
62
8
61
5
60
3
59
4
58
1
55
2
54
1
53
1

Test runs: 233Avg run : 0.006039 seconds Test time: 1.407119 seconds Data Save: 0.031282 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