SQLite ORDER BY RANDOM() Randomosity Tester

+10,000 data

+1 +10 +100 +1K +10K +MAX
range: 1-50, data points: 10,000, groups: 28
High / Low / Range / Average
Frequency: 235 / 167 / 68 / 200.00
Rows: 5 / 1 / 4 / 1.79

235

231

219

216

212

211

210

209

207

205

204

202

199

198

197

196

194

193

192

191

190

189

186

185

183

181

179

167

Test runs: 10,000Avg run : 0.000043 seconds Test time: 0.429033 seconds Data Save: 0.011725 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:

SQLite ORDER BY RANDOM()
PHP rand()
PHP mt_rand()
PHP random_int()

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:

Frequency: the list of unique frequencies (the number of times a row was randomly selected)
Rows: the number of rows for each frequency present

This site was created with Open Source software. Find out more on Github: randomosity-tester v0.2.2

Show Ads