diff options
| author | unknown <monty@hundin.mysql.fi> | 2001-08-26 23:24:48 +0300 |
|---|---|---|
| committer | unknown <monty@hundin.mysql.fi> | 2001-08-26 23:24:48 +0300 |
| commit | c0d11f1e7be4904f0239e5171987a76322c21a0e (patch) | |
| tree | 7df1f3b7860b5ebb86cad40aa765d858dcbe716b /sql-bench/test-select.sh | |
| parent | cbc16b796be9cd8eedb96b2c398da2e76b9b9f1b (diff) | |
| download | mariadb-git-c0d11f1e7be4904f0239e5171987a76322c21a0e.tar.gz | |
Fixed bug in auto-increment handling with InnoDB
Some small speedups
Docs/manual.texi:
Changelog
client/mysqldump.c:
Fixed quoting problem for table names when using --opt
mysys/mf_casecnv.c:
Speed up some common string functions
sql-bench/test-insert.sh:
Small changes that shouldn't affect results
sql-bench/test-select.sh:
Small changes that shouldn't affect results
sql/field.h:
Added reset() functions to speed up some common things
sql/gen_lex_hash.cc:
Smaller hash table
sql/ha_innobase.cc:
Fixed bug in auto-increment handling with InnoDB
Diffstat (limited to 'sql-bench/test-select.sh')
| -rw-r--r-- | sql-bench/test-select.sh | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/sql-bench/test-select.sh b/sql-bench/test-select.sh index 3c7efe3c5c2..1ecad5804c5 100644 --- a/sql-bench/test-select.sh +++ b/sql-bench/test-select.sh @@ -136,12 +136,12 @@ if ($limits->{'group_functions'}) print "Test if the database has a query cache\n"; # First ensure that the table is read into memory - fetch_all_rows($dbh,"select sum(idn+$tmp),sum(rev_idn+$tmp) from bench1"); + fetch_all_rows($dbh,"select sum(idn+$tmp),sum(rev_idn-$tmp) from bench1"); $loop_time=new Benchmark; for ($tests=0 ; $tests < $opt_loop_count ; $tests++) { - fetch_all_rows($dbh,"select sum(idn+$tests),sum(rev_idn+$tests) from bench1"); + fetch_all_rows($dbh,"select sum(idn+$tests),sum(rev_idn-$tests) from bench1"); } $end_time=new Benchmark; print "Time for select_query_cache ($opt_loop_count): " . @@ -153,7 +153,7 @@ if ($limits->{'group_functions'}) $loop_time=new Benchmark; for ($tests=0 ; $tests < $opt_loop_count ; $tests++) { - fetch_all_rows($dbh,"select sum(idn+$tests),sum(rev_idn+$tests) from bench1"); + fetch_all_rows($dbh,"select sum(idn+$tests),sum(rev_idn-$tests) from bench1"); } $end_time=new Benchmark; print "Time for select_query_cache2 ($opt_loop_count): " . |