Lines Matching refs:random
21 # Set a uniform random seed
172 # 100000 random SELECTs against rowid.
181 # 100000 random SELECTs against a unique indexed column.
190 # 50000 random SELECTs against an indexed column text column
193 db eval {SELECT c FROM t1 ORDER BY random() LIMIT 50000} {
213 # 100000 random SELECTs against rowid.
222 # 100000 random SELECTs against a unique indexed column.
231 # 50000 random SELECTs against an indexed column text column
234 db eval {SELECT c FROM t1 ORDER BY random() LIMIT 50000} {
310 # Select 20000 rows from the table at random.
313 SELECT rowid FROM t1 ORDER BY random() LIMIT 20000
316 # Delete 20000 random rows from the table.
318 speed_trial speed2-random-del1 20000 row {
320 (SELECT rowid FROM t1 ORDER BY random() LIMIT 20000)
327 # Delete 20000 more rows at random from the table.
329 speed_trial speed2-random-del2 20000 row {
331 (SELECT rowid FROM t1 ORDER BY random() LIMIT 20000)