Lines Matching refs:random

23 # Set a uniform random seed
189 # 100000 random SELECTs against rowid.
206 # 100000 random SELECTs against a unique indexed column.
223 # 50000 random SELECTs against an indexed column text column
225 set list [db eval {SELECT c FROM t1 ORDER BY random() LIMIT 50000}]
335 # Select 20000 rows from the table at random.
337 explain {SELECT rowid FROM t1 ORDER BY random() LIMIT 20000}
339   SELECT rowid FROM t1 ORDER BY random() LIMIT 20000
342 # Delete 20000 random rows from the table.
345     (SELECT rowid FROM t1 ORDER BY random() LIMIT 20000)}
346 speed_trial speed1p-random-del1 20000 row {
348     (SELECT rowid FROM t1 ORDER BY random() LIMIT 20000)
355 # Delete 20000 more rows at random from the table.
357 speed_trial speed1p-random-del2 20000 row {
359     (SELECT rowid FROM t1 ORDER BY random() LIMIT 20000)