Hide Ads
 Refresh   About   Tools 

SQLite ORDER BY RANDOM() Randomosity Tester

TIMEOUT
+7,591 data
+1 +10 +100 +1K +10K +MAX
range: 1-50, data points: 706,362, groups: 48
High / Low / Range / Average
Frequency: 14,298 / 13,880 / 418 / 14,127.24
Rows: 2 / 1 / 1 / 1.04
Frequency
Rows
14,298
1
14,297
1
14,294
1
14,291
1
14,263
1
14,253
1
14,250
1
14,234
1
14,227
1
14,216
1
14,212
1
14,206
1
14,197
1
14,194
1
14,192
1
14,179
2
14,170
1
14,165
1
14,161
1
14,158
1
14,152
1
14,147
1
14,145
1
14,143
1
14,139
1
14,137
1
14,127
1
14,121
1
14,120
1
14,119
1
14,108
1
14,107
1
14,093
1
14,082
1
14,078
1
14,076
1
14,047
1
14,043
1
14,034
1
14,026
1
14,021
1
14,009
1
13,991
1
13,973
2
13,971
1
13,958
1
13,906
1
13,880
1

Test runs: 7,592Avg run : 0.000188 seconds Test time: 1.424507 seconds Data Save: 0.023799 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 50.

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