/ Check-in [7922809e]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Adjust the repeat counts on several tests in speedtest1 so that the relative time spent on the test is roughly the same regardless of --size.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1:7922809ee0d3978ce9221fbb7df63aa0684d0c4d
User & Date: drh 2014-03-25 20:28:38
Context
2014-03-26
12:02
Add an assert() and a comment to clarify the operation of the vdbeRecordCompareInt() routine. check-in: 851abdb8 user: drh tags: trunk
2014-03-25
20:28
Adjust the repeat counts on several tests in speedtest1 so that the relative time spent on the test is roughly the same regardless of --size. check-in: 7922809e user: drh tags: trunk
17:45
Add another performance test case to speedtest1. This case is another ORDER BY test but this time without LIMIT. check-in: 9ab7ffd5 user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to test/speedtest1.c.

   470    470       sqlite3_bind_text(g.pStmt, 3, zNum, -1, SQLITE_STATIC);
   471    471       speedtest1_run();
   472    472     }
   473    473     speedtest1_exec("COMMIT");
   474    474     speedtest1_end_test();
   475    475   
   476    476   
   477         -  n = g.szTest/2;
          477  +  n = 25;
   478    478     speedtest1_begin_test(130, "%d SELECTS, numeric BETWEEN, unindexed", n);
   479    479     speedtest1_exec("BEGIN");
   480    480     speedtest1_prepare(
   481    481       "SELECT count(*), avg(b), sum(length(c)) FROM t1\n"
   482    482       " WHERE b BETWEEN ?1 AND ?2; -- %d times", n
   483    483     );
   484    484     for(i=1; i<=n; i++){
................................................................................
   488    488       sqlite3_bind_int(g.pStmt, 2, x2);
   489    489       speedtest1_run();
   490    490     }
   491    491     speedtest1_exec("COMMIT");
   492    492     speedtest1_end_test();
   493    493   
   494    494   
   495         -  n = g.szTest/5;
          495  +  n = 10;
   496    496     speedtest1_begin_test(140, "%d SELECTS, LIKE, unindexed", n);
   497    497     speedtest1_exec("BEGIN");
   498    498     speedtest1_prepare(
   499    499       "SELECT count(*), avg(b), sum(length(c)) FROM t1\n"
   500    500       " WHERE c LIKE ?1; -- %d times", n
   501    501     );
   502    502     for(i=1; i<=n; i++){
................................................................................
   508    508       sqlite3_bind_text(g.pStmt, 1, zNum, len, SQLITE_STATIC);
   509    509       speedtest1_run();
   510    510     }
   511    511     speedtest1_exec("COMMIT");
   512    512     speedtest1_end_test();
   513    513   
   514    514   
   515         -  n = g.szTest/5;
          515  +  n = 10;
   516    516     speedtest1_begin_test(142, "%d SELECTS w/ORDER BY, unindexed", n);
   517    517     speedtest1_exec("BEGIN");
   518    518     speedtest1_prepare(
   519    519       "SELECT a, b, c FROM t1 WHERE c LIKE ?1\n"
   520    520       " ORDER BY a; -- %d times", n
   521    521     );
   522    522     for(i=1; i<=n; i++){
................................................................................
   527    527       zNum[len+1] = 0;
   528    528       sqlite3_bind_text(g.pStmt, 1, zNum, len, SQLITE_STATIC);
   529    529       speedtest1_run();
   530    530     }
   531    531     speedtest1_exec("COMMIT");
   532    532     speedtest1_end_test();
   533    533   
   534         -  n = g.szTest/5;
          534  +  n = 10; //g.szTest/5;
   535    535     speedtest1_begin_test(145, "%d SELECTS w/ORDER BY and LIMIT, unindexed", n);
   536    536     speedtest1_exec("BEGIN");
   537    537     speedtest1_prepare(
   538    538       "SELECT a, b, c FROM t1 WHERE c LIKE ?1\n"
   539    539       " ORDER BY a LIMIT 10; -- %d times", n
   540    540     );
   541    541     for(i=1; i<=n; i++){