~drizzle-trunk/drizzle/development

Committer: Stewart Smith
Date: 2009-03-11 03:21:08 UTC
mto: (910.4.19 sparc) (937.2.1 sparc)
mto: This revision was merged to the branch mainline in revision 931.
Revision ID: stewart@flamingspork.com-20090311032108-2qn3uydzr01v0xtv

dramatically speed up derived test.

Wrap 10,000 row load in transaction.

Shaves 2 seconds off test for libeatmydata runs.
Shaves about 335 seconds off test for normal runs (non-libeatmydata. i.e. fsync is real)

files modified:
tests/t/derived.test

Show diffs side-by-side

added added

removed removed

tests/t/derived.test

drop table t1, t2;

create table t1(a int not null, t char(8), index(a));

disable_query_log;

begin;

let $1 = 10000;

while ($1)

{

eval insert into t1 values ($1,'$1');

dec $1;

}

commit;

enable_query_log;

SELECT * FROM (SELECT * FROM t1) as b ORDER BY a ASC LIMIT 0,20;

--replace_column 9 X

Older »