Lines Matching refs:random
25 # Set a uniform random seed
158 # 100000 random SELECTs against rowid.
169 # 100000 random SELECTs against a unique indexed column.
180 # 50000 random SELECTs against an indexed column text column
183 db eval {SELECT c FROM t1 ORDER BY random() LIMIT 50000} {
265 # Select 20000 rows from the table at random.
268 SELECT rowid FROM t1 ORDER BY random() LIMIT 20000
271 # Delete 20000 random rows from the table.
273 speed_trial speed1-random-del1 20000 row {
275 (SELECT rowid FROM t1 ORDER BY random() LIMIT 20000)
282 # Delete 20000 more rows at random from the table.
284 speed_trial speed1-random-del2 20000 row {
286 (SELECT rowid FROM t1 ORDER BY random() LIMIT 20000)