Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Add the new "--testset orm" to the speedtest1 utility. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
1836adc1d1f8e496ae0a07bf0fc933a1 |
User & Date: | drh 2017-02-14 15:57:11.586 |
Context
2017-02-14
| ||
15:58 | Fix a testcase number on the ORM testset of speedtest1. (check-in: 58b2f911ee user: drh tags: trunk) | |
15:57 | Add the new "--testset orm" to the speedtest1 utility. (check-in: 1836adc1d1 user: drh tags: trunk) | |
2017-02-13
| ||
13:35 | Change all legacy instances of "#if SQLITE_DEBUG" to "#ifdef SQLITE_DEBUG" for consistency. (check-in: 670f10b242 user: drh tags: trunk) | |
Changes
Changes to test/speedtest1.c.
︙ | ︙ | |||
29 30 31 32 33 34 35 | " --serialized Set serialized threading mode\n" " --singlethread Set single-threaded mode - disables all mutexing\n" " --sqlonly No-op. Only show the SQL that would have been run.\n" " --shrink-memory Invoke sqlite3_db_release_memory() frequently.\n" " --size N Relative test size. Default=100\n" " --stats Show statistics at the end\n" " --temp N N from 0 to 9. 0: no temp table. 9: all temp tables\n" | | | 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 | " --serialized Set serialized threading mode\n" " --singlethread Set single-threaded mode - disables all mutexing\n" " --sqlonly No-op. Only show the SQL that would have been run.\n" " --shrink-memory Invoke sqlite3_db_release_memory() frequently.\n" " --size N Relative test size. Default=100\n" " --stats Show statistics at the end\n" " --temp N N from 0 to 9. 0: no temp table. 9: all temp tables\n" " --testset T Run test-set T (main, cte, rtree, orm, debug)\n" " --trace Turn on SQL tracing\n" " --threads N Use up to N threads for sorting\n" " --utf16be Set text encoding to UTF-16BE\n" " --utf16le Set text encoding to UTF-16LE\n" " --verify Run additional verification steps.\n" " --without-rowid Use WITHOUT ROWID where appropriate\n" ; |
︙ | ︙ | |||
1302 1303 1304 1305 1306 1307 1308 1309 1310 1311 1312 1313 1314 1315 | for(i=1; i<=n; i++){ sqlite3_bind_int(g.pStmt, 1, i); speedtest1_run(); } speedtest1_end_test(); } #endif /* SQLITE_ENABLE_RTREE */ /* ** A testset used for debugging speedtest1 itself. */ void testset_debug1(void){ unsigned i, n; unsigned x1, x2; | > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > | 1302 1303 1304 1305 1306 1307 1308 1309 1310 1311 1312 1313 1314 1315 1316 1317 1318 1319 1320 1321 1322 1323 1324 1325 1326 1327 1328 1329 1330 1331 1332 1333 1334 1335 1336 1337 1338 1339 1340 1341 1342 1343 1344 1345 1346 1347 1348 1349 1350 1351 1352 1353 1354 1355 1356 1357 1358 1359 1360 1361 1362 1363 1364 1365 1366 1367 1368 1369 1370 1371 1372 1373 1374 1375 1376 1377 1378 1379 1380 1381 1382 1383 1384 1385 1386 1387 1388 1389 1390 1391 1392 1393 1394 1395 1396 1397 1398 1399 1400 1401 1402 1403 1404 1405 1406 1407 1408 1409 1410 1411 1412 1413 1414 1415 1416 1417 1418 1419 1420 1421 1422 1423 1424 1425 1426 1427 1428 1429 1430 1431 1432 1433 1434 1435 1436 1437 1438 1439 1440 1441 1442 1443 1444 1445 1446 1447 1448 1449 1450 1451 1452 1453 1454 1455 1456 1457 1458 1459 1460 1461 1462 1463 1464 1465 1466 1467 1468 1469 1470 1471 1472 1473 1474 1475 1476 1477 1478 1479 1480 1481 1482 1483 1484 1485 1486 1487 1488 1489 1490 1491 1492 1493 1494 1495 1496 1497 1498 1499 1500 1501 1502 1503 1504 1505 1506 1507 1508 1509 1510 1511 1512 1513 1514 1515 1516 1517 1518 1519 1520 1521 1522 1523 1524 1525 1526 1527 1528 1529 1530 1531 1532 1533 1534 1535 1536 1537 1538 1539 1540 1541 1542 1543 1544 1545 1546 1547 1548 1549 1550 1551 1552 1553 1554 1555 1556 1557 1558 1559 1560 1561 1562 1563 1564 1565 1566 1567 1568 1569 1570 1571 1572 1573 1574 1575 1576 1577 1578 1579 1580 1581 1582 1583 1584 | for(i=1; i<=n; i++){ sqlite3_bind_int(g.pStmt, 1, i); speedtest1_run(); } speedtest1_end_test(); } #endif /* SQLITE_ENABLE_RTREE */ /* ** A testset that does key/value storage on tables with many columns. ** This is the kind of workload generated by ORMs such as CoreData. */ void testset_orm(void){ unsigned i, j, n; unsigned nRow; unsigned x1, len; char zNum[2000]; /* A number name */ static const char zType[] = /* Types for all non-PK columns, in order */ "IBBIIITIVVITBTBFBFITTFBTBVBVIFTBBFITFFVBIFIVBVVVBTVTIBBFFIVIBTB" "TVTTFTVTVFFIITIFBITFTTFFFVBIIBTTITFTFFVVVFIIITVBBVFFTVVB"; nRow = n = g.szTest*250; speedtest1_begin_test(100, "Fill %d rows", n); speedtest1_exec( "BEGIN;" "CREATE TABLE ZLOOKSLIKECOREDATA (" " ZPK INTEGER PRIMARY KEY," " ZTERMFITTINGHOUSINGCOMMAND INTEGER," " ZBRIEFGOBYDODGERHEIGHT BLOB," " ZCAPABLETRIPDOORALMOND BLOB," " ZDEPOSITPAIRCOLLEGECOMET INTEGER," " ZFRAMEENTERSIMPLEMOUTH INTEGER," " ZHOPEFULGATEHOLECHALK INTEGER," " ZSLEEPYUSERGRANDBOWL TIMESTAMP," " ZDEWPEACHCAREERCELERY INTEGER," " ZHANGERLITHIUMDINNERMEET VARCHAR," " ZCLUBRELEASELIZARDADVICE VARCHAR," " ZCHARGECLICKHUMANEHIRE INTEGER," " ZFINGERDUEPIZZAOPTION TIMESTAMP," " ZFLYINGDOCTORTABLEMELODY BLOB," " ZLONGFINLEAVEIMAGEOIL TIMESTAMP," " ZFAMILYVISUALOWNERMATTER BLOB," " ZGOLDYOUNGINITIALNOSE FLOAT," " ZCAUSESALAMITERMCYAN BLOB," " ZSPREADMOTORBISCUITBACON FLOAT," " ZGIFTICEFISHGLUEHAIR INTEGER," " ZNOTICEPEARPOLICYJUICE TIMESTAMP," " ZBANKBUFFALORECOVERORBIT TIMESTAMP," " ZLONGDIETESSAYNATURE FLOAT," " ZACTIONRANGEELEGANTNEUTRON BLOB," " ZCADETBRIGHTPLANETBANK TIMESTAMP," " ZAIRFORGIVEHEADFROG BLOB," " ZSHARKJUSTFRUITMOVIE VARCHAR," " ZFARMERMORNINGMIRRORCONCERN BLOB," " ZWOODPOETRYCOBBLERBENCH VARCHAR," " ZHAFNIUMSCRIPTSALADMOTOR INTEGER," " ZPROBLEMCLUBPOPOVERJELLY FLOAT," " ZEIGHTLEADERWORKERMOST TIMESTAMP," " ZGLASSRESERVEBARIUMMEAL BLOB," " ZCLAMBITARUGULAFAJITA BLOB," " ZDECADEJOYOUSWAVEHABIT FLOAT," " ZCOMPANYSUMMERFIBERELF INTEGER," " ZTREATTESTQUILLCHARGE TIMESTAMP," " ZBROWBALANCEKEYCHOWDER FLOAT," " ZPEACHCOPPERDINNERLAKE FLOAT," " ZDRYWALLBEYONDBROWNBOWL VARCHAR," " ZBELLYCRASHITEMLACK BLOB," " ZTENNISCYCLEBILLOFFICER INTEGER," " ZMALLEQUIPTHANKSGLUE FLOAT," " ZMISSREPLYHUMANLIVING INTEGER," " ZKIWIVISUALPRIDEAPPLE VARCHAR," " ZWISHHITSKINMOTOR BLOB," " ZCALMRACCOONPROGRAMDEBIT VARCHAR," " ZSHINYASSISTLIVINGCRAB VARCHAR," " ZRESOLVEWRISTWRAPAPPLE VARCHAR," " ZAPPEALSIMPLESECONDHOUSING BLOB," " ZCORNERANCHORTAPEDIVER TIMESTAMP," " ZMEMORYREQUESTSOURCEBIG VARCHAR," " ZTRYFACTKEEPMILK TIMESTAMP," " ZDIVERPAINTLEATHEREASY INTEGER," " ZSORTMISTYQUOTECABBAGE BLOB," " ZTUNEGASBUFFALOCAPITAL BLOB," " ZFILLSTOPLAWJOYFUL FLOAT," " ZSTEELCAREFULPLATENUMBER FLOAT," " ZGIVEVIVIDDIVINEMEANING INTEGER," " ZTREATPACKFUTURECONVERT VARCHAR," " ZCALMLYGEMFINISHEFFECT INTEGER," " ZCABBAGESOCKEASEMINUTE BLOB," " ZPLANETFAMILYPUREMEMORY TIMESTAMP," " ZMERRYCRACKTRAINLEADER BLOB," " ZMINORWAYPAPERCLASSY TIMESTAMP," " ZEAGLELINEMINEMAIL VARCHAR," " ZRESORTYARDGREENLET TIMESTAMP," " ZYARDOREGANOVIVIDJEWEL TIMESTAMP," " ZPURECAKEVIVIDNEATLY FLOAT," " ZASKCONTACTMONITORFUN TIMESTAMP," " ZMOVEWHOGAMMAINCH VARCHAR," " ZLETTUCEBIRDMEETDEBATE TIMESTAMP," " ZGENENATURALHEARINGKITE VARCHAR," " ZMUFFINDRYERDRAWFORTUNE FLOAT," " ZGRAYSURVEYWIRELOVE FLOAT," " ZPLIERSPRINTASKOREGANO INTEGER," " ZTRAVELDRIVERCONTESTLILY INTEGER," " ZHUMORSPICESANDKIDNEY TIMESTAMP," " ZARSENICSAMPLEWAITMUON INTEGER," " ZLACEADDRESSGROUNDCAREFUL FLOAT," " ZBAMBOOMESSWASABIEVENING BLOB," " ZONERELEASEAVERAGENURSE INTEGER," " ZRADIANTWHENTRYCARD TIMESTAMP," " ZREWARDINSIDEMANGOINTENSE FLOAT," " ZNEATSTEWPARTIRON TIMESTAMP," " ZOUTSIDEPEAHENCOUNTICE TIMESTAMP," " ZCREAMEVENINGLIPBRANCH FLOAT," " ZWHALEMATHAVOCADOCOPPER FLOAT," " ZLIFEUSELEAFYBELL FLOAT," " ZWEALTHLINENGLEEFULDAY VARCHAR," " ZFACEINVITETALKGOLD BLOB," " ZWESTAMOUNTAFFECTHEARING INTEGER," " ZDELAYOUTCOMEHORNAGENCY INTEGER," " ZBIGTHINKCONVERTECONOMY BLOB," " ZBASEGOUDAREGULARFORGIVE TIMESTAMP," " ZPATTERNCLORINEGRANDCOLBY TIMESTAMP," " ZCYANBASEFEEDADROIT INTEGER," " ZCARRYFLOORMINNOWDRAGON TIMESTAMP," " ZIMAGEPENCILOTHERBOTTOM FLOAT," " ZXENONFLIGHTPALEAPPLE TIMESTAMP," " ZHERRINGJOKEFEATUREHOPEFUL FLOAT," " ZCAPYEARLYRIVETBRUSH FLOAT," " ZAGEREEDFROGBASKET VARCHAR," " ZUSUALBODYHALIBUTDIAMOND VARCHAR," " ZFOOTTAPWORDENTRY VARCHAR," " ZDISHKEEPBLESTMONITOR FLOAT," " ZBROADABLESOLIDCASUAL INTEGER," " ZSQUAREGLEEFULCHILDLIGHT INTEGER," " ZHOLIDAYHEADPONYDETAIL INTEGER," " ZGENERALRESORTSKYOPEN TIMESTAMP," " ZGLADSPRAYKIDNEYGUPPY VARCHAR," " ZSWIMHEAVYMENTIONKIND BLOB," " ZMESSYSULFURDREAMFESTIVE BLOB," " ZSKYSKYCLASSICBRIEF VARCHAR," " ZDILLASKHOKILEMON FLOAT," " ZJUNIORSHOWPRESSNOVA FLOAT," " ZSIZETOEAWARDFRESH TIMESTAMP," " ZKEYFAILAPRICOTMETAL VARCHAR," " ZHANDYREPAIRPROTONAIRPORT VARCHAR," " ZPOSTPROTEINHANDLEACTOR BLOB" ");" ); speedtest1_prepare( "INSERT INTO ZLOOKSLIKECOREDATA(ZPK,ZAIRFORGIVEHEADFROG," "ZGIFTICEFISHGLUEHAIR,ZDELAYOUTCOMEHORNAGENCY,ZSLEEPYUSERGRANDBOWL," "ZGLASSRESERVEBARIUMMEAL,ZBRIEFGOBYDODGERHEIGHT," "ZBAMBOOMESSWASABIEVENING,ZFARMERMORNINGMIRRORCONCERN," "ZTREATPACKFUTURECONVERT,ZCAUSESALAMITERMCYAN,ZCALMRACCOONPROGRAMDEBIT," "ZHOLIDAYHEADPONYDETAIL,ZWOODPOETRYCOBBLERBENCH,ZHAFNIUMSCRIPTSALADMOTOR," "ZUSUALBODYHALIBUTDIAMOND,ZOUTSIDEPEAHENCOUNTICE,ZDIVERPAINTLEATHEREASY," "ZWESTAMOUNTAFFECTHEARING,ZSIZETOEAWARDFRESH,ZDEWPEACHCAREERCELERY," "ZSTEELCAREFULPLATENUMBER,ZCYANBASEFEEDADROIT,ZCALMLYGEMFINISHEFFECT," "ZHANDYREPAIRPROTONAIRPORT,ZGENENATURALHEARINGKITE,ZBROADABLESOLIDCASUAL," "ZPOSTPROTEINHANDLEACTOR,ZLACEADDRESSGROUNDCAREFUL,ZIMAGEPENCILOTHERBOTTOM," "ZPROBLEMCLUBPOPOVERJELLY,ZPATTERNCLORINEGRANDCOLBY,ZNEATSTEWPARTIRON," "ZAPPEALSIMPLESECONDHOUSING,ZMOVEWHOGAMMAINCH,ZTENNISCYCLEBILLOFFICER," "ZSHARKJUSTFRUITMOVIE,ZKEYFAILAPRICOTMETAL,ZCOMPANYSUMMERFIBERELF," "ZTERMFITTINGHOUSINGCOMMAND,ZRESORTYARDGREENLET,ZCABBAGESOCKEASEMINUTE," "ZSQUAREGLEEFULCHILDLIGHT,ZONERELEASEAVERAGENURSE,ZBIGTHINKCONVERTECONOMY," "ZPLIERSPRINTASKOREGANO,ZDECADEJOYOUSWAVEHABIT,ZDRYWALLBEYONDBROWNBOWL," "ZCLUBRELEASELIZARDADVICE,ZWHALEMATHAVOCADOCOPPER,ZBELLYCRASHITEMLACK," "ZLETTUCEBIRDMEETDEBATE,ZCAPABLETRIPDOORALMOND,ZRADIANTWHENTRYCARD," "ZCAPYEARLYRIVETBRUSH,ZAGEREEDFROGBASKET,ZSWIMHEAVYMENTIONKIND," "ZTRAVELDRIVERCONTESTLILY,ZGLADSPRAYKIDNEYGUPPY,ZBANKBUFFALORECOVERORBIT," "ZFINGERDUEPIZZAOPTION,ZCLAMBITARUGULAFAJITA,ZLONGFINLEAVEIMAGEOIL," "ZLONGDIETESSAYNATURE,ZJUNIORSHOWPRESSNOVA,ZHOPEFULGATEHOLECHALK," "ZDEPOSITPAIRCOLLEGECOMET,ZWEALTHLINENGLEEFULDAY,ZFILLSTOPLAWJOYFUL," "ZTUNEGASBUFFALOCAPITAL,ZGRAYSURVEYWIRELOVE,ZCORNERANCHORTAPEDIVER," "ZREWARDINSIDEMANGOINTENSE,ZCADETBRIGHTPLANETBANK,ZPLANETFAMILYPUREMEMORY," "ZTREATTESTQUILLCHARGE,ZCREAMEVENINGLIPBRANCH,ZSKYSKYCLASSICBRIEF," "ZARSENICSAMPLEWAITMUON,ZBROWBALANCEKEYCHOWDER,ZFLYINGDOCTORTABLEMELODY," "ZHANGERLITHIUMDINNERMEET,ZNOTICEPEARPOLICYJUICE,ZSHINYASSISTLIVINGCRAB," "ZLIFEUSELEAFYBELL,ZFACEINVITETALKGOLD,ZGENERALRESORTSKYOPEN," "ZPURECAKEVIVIDNEATLY,ZKIWIVISUALPRIDEAPPLE,ZMESSYSULFURDREAMFESTIVE," "ZCHARGECLICKHUMANEHIRE,ZHERRINGJOKEFEATUREHOPEFUL,ZYARDOREGANOVIVIDJEWEL," "ZFOOTTAPWORDENTRY,ZWISHHITSKINMOTOR,ZBASEGOUDAREGULARFORGIVE," "ZMUFFINDRYERDRAWFORTUNE,ZACTIONRANGEELEGANTNEUTRON,ZTRYFACTKEEPMILK," "ZPEACHCOPPERDINNERLAKE,ZFRAMEENTERSIMPLEMOUTH,ZMERRYCRACKTRAINLEADER," "ZMEMORYREQUESTSOURCEBIG,ZCARRYFLOORMINNOWDRAGON,ZMINORWAYPAPERCLASSY," "ZDILLASKHOKILEMON,ZRESOLVEWRISTWRAPAPPLE,ZASKCONTACTMONITORFUN," "ZGIVEVIVIDDIVINEMEANING,ZEIGHTLEADERWORKERMOST,ZMISSREPLYHUMANLIVING," "ZXENONFLIGHTPALEAPPLE,ZSORTMISTYQUOTECABBAGE,ZEAGLELINEMINEMAIL," "ZFAMILYVISUALOWNERMATTER,ZSPREADMOTORBISCUITBACON,ZDISHKEEPBLESTMONITOR," "ZMALLEQUIPTHANKSGLUE,ZGOLDYOUNGINITIALNOSE,ZHUMORSPICESANDKIDNEY)" "VALUES(?1,?26,?20,?93,?8,?33,?3,?81,?28,?60,?18,?47,?109,?29,?30,?104,?86," "?54,?92,?117,?9,?58,?97,?61,?119,?73,?107,?120,?80,?99,?31,?96,?85,?50,?71," "?42,?27,?118,?36,?2,?67,?62,?108,?82,?94,?76,?35,?40,?11,?88,?41,?72,?4," "?83,?102,?103,?112,?77,?111,?22,?13,?34,?15,?23,?116,?7,?5,?90,?57,?56," "?75,?51,?84,?25,?63,?37,?87,?114,?79,?38,?14,?10,?21,?48,?89,?91,?110," "?69,?45,?113,?12,?101,?68,?105,?46,?95,?74,?24,?53,?39,?6,?64,?52,?98," "?65,?115,?49,?70,?59,?32,?44,?100,?55,?66,?16,?19,?106,?43,?17,?78);" ); for(i=0; i<n; i++){ x1 = speedtest1_random(); speedtest1_numbername(x1, zNum, sizeof(zNum)); len = (int)strlen(zNum); sqlite3_bind_int(g.pStmt, 1, i^0xf); for(j=0; zType[j]; j++){ switch( zType[j] ){ case 'I': case 'T': sqlite3_bind_int(g.pStmt, j+2, x1); break; case 'F': sqlite3_bind_double(g.pStmt, j+2, (double)x1); break; case 'V': case 'B': sqlite3_bind_text64(g.pStmt, j+2, zNum, len, SQLITE_STATIC, SQLITE_UTF8); break; } } speedtest1_run(); } speedtest1_exec("COMMIT;"); speedtest1_end_test(); n = g.szTest*250; speedtest1_begin_test(100, "Query %d rows by rowid", n); speedtest1_prepare( "SELECT ZCYANBASEFEEDADROIT,ZJUNIORSHOWPRESSNOVA,ZCAUSESALAMITERMCYAN," "ZHOPEFULGATEHOLECHALK,ZHUMORSPICESANDKIDNEY,ZSWIMHEAVYMENTIONKIND," "ZMOVEWHOGAMMAINCH,ZAPPEALSIMPLESECONDHOUSING,ZHAFNIUMSCRIPTSALADMOTOR," "ZNEATSTEWPARTIRON,ZLONGFINLEAVEIMAGEOIL,ZDEWPEACHCAREERCELERY," "ZXENONFLIGHTPALEAPPLE,ZCALMRACCOONPROGRAMDEBIT,ZUSUALBODYHALIBUTDIAMOND," "ZTRYFACTKEEPMILK,ZWEALTHLINENGLEEFULDAY,ZLONGDIETESSAYNATURE," "ZLIFEUSELEAFYBELL,ZTREATPACKFUTURECONVERT,ZMEMORYREQUESTSOURCEBIG," "ZYARDOREGANOVIVIDJEWEL,ZDEPOSITPAIRCOLLEGECOMET,ZSLEEPYUSERGRANDBOWL," "ZBRIEFGOBYDODGERHEIGHT,ZCLUBRELEASELIZARDADVICE,ZCAPABLETRIPDOORALMOND," "ZDRYWALLBEYONDBROWNBOWL,ZASKCONTACTMONITORFUN,ZKIWIVISUALPRIDEAPPLE," "ZNOTICEPEARPOLICYJUICE,ZPEACHCOPPERDINNERLAKE,ZSTEELCAREFULPLATENUMBER," "ZGLADSPRAYKIDNEYGUPPY,ZCOMPANYSUMMERFIBERELF,ZTENNISCYCLEBILLOFFICER," "ZIMAGEPENCILOTHERBOTTOM,ZWESTAMOUNTAFFECTHEARING,ZDIVERPAINTLEATHEREASY," "ZSKYSKYCLASSICBRIEF,ZMESSYSULFURDREAMFESTIVE,ZMERRYCRACKTRAINLEADER," "ZBROADABLESOLIDCASUAL,ZGLASSRESERVEBARIUMMEAL,ZTUNEGASBUFFALOCAPITAL," "ZBANKBUFFALORECOVERORBIT,ZTREATTESTQUILLCHARGE,ZBAMBOOMESSWASABIEVENING," "ZREWARDINSIDEMANGOINTENSE,ZEAGLELINEMINEMAIL,ZCALMLYGEMFINISHEFFECT," "ZKEYFAILAPRICOTMETAL,ZFINGERDUEPIZZAOPTION,ZCADETBRIGHTPLANETBANK," "ZGOLDYOUNGINITIALNOSE,ZMISSREPLYHUMANLIVING,ZEIGHTLEADERWORKERMOST," "ZFRAMEENTERSIMPLEMOUTH,ZBIGTHINKCONVERTECONOMY,ZFACEINVITETALKGOLD," "ZPOSTPROTEINHANDLEACTOR,ZHERRINGJOKEFEATUREHOPEFUL,ZCABBAGESOCKEASEMINUTE," "ZMUFFINDRYERDRAWFORTUNE,ZPROBLEMCLUBPOPOVERJELLY,ZGIVEVIVIDDIVINEMEANING," "ZGENENATURALHEARINGKITE,ZGENERALRESORTSKYOPEN,ZLETTUCEBIRDMEETDEBATE," "ZBASEGOUDAREGULARFORGIVE,ZCHARGECLICKHUMANEHIRE,ZPLANETFAMILYPUREMEMORY," "ZMINORWAYPAPERCLASSY,ZCAPYEARLYRIVETBRUSH,ZSIZETOEAWARDFRESH," "ZARSENICSAMPLEWAITMUON,ZSQUAREGLEEFULCHILDLIGHT,ZSHINYASSISTLIVINGCRAB," "ZCORNERANCHORTAPEDIVER,ZDECADEJOYOUSWAVEHABIT,ZTRAVELDRIVERCONTESTLILY," "ZFLYINGDOCTORTABLEMELODY,ZSHARKJUSTFRUITMOVIE,ZFAMILYVISUALOWNERMATTER," "ZFARMERMORNINGMIRRORCONCERN,ZGIFTICEFISHGLUEHAIR,ZOUTSIDEPEAHENCOUNTICE," "ZSPREADMOTORBISCUITBACON,ZWISHHITSKINMOTOR,ZHOLIDAYHEADPONYDETAIL," "ZWOODPOETRYCOBBLERBENCH,ZAIRFORGIVEHEADFROG,ZBROWBALANCEKEYCHOWDER," "ZDISHKEEPBLESTMONITOR,ZCLAMBITARUGULAFAJITA,ZPLIERSPRINTASKOREGANO," "ZRADIANTWHENTRYCARD,ZDELAYOUTCOMEHORNAGENCY,ZPURECAKEVIVIDNEATLY," "ZPATTERNCLORINEGRANDCOLBY,ZHANDYREPAIRPROTONAIRPORT,ZAGEREEDFROGBASKET," "ZSORTMISTYQUOTECABBAGE,ZFOOTTAPWORDENTRY,ZRESOLVEWRISTWRAPAPPLE," "ZDILLASKHOKILEMON,ZFILLSTOPLAWJOYFUL,ZACTIONRANGEELEGANTNEUTRON," "ZRESORTYARDGREENLET,ZCREAMEVENINGLIPBRANCH,ZWHALEMATHAVOCADOCOPPER," "ZGRAYSURVEYWIRELOVE,ZBELLYCRASHITEMLACK,ZHANGERLITHIUMDINNERMEET," "ZCARRYFLOORMINNOWDRAGON,ZMALLEQUIPTHANKSGLUE,ZTERMFITTINGHOUSINGCOMMAND," "ZONERELEASEAVERAGENURSE,ZLACEADDRESSGROUNDCAREFUL" " FROM ZLOOKSLIKECOREDATA WHERE ZPK=?1;" ); for(i=0; i<n; i++){ x1 = speedtest1_random()%nRow; sqlite3_bind_int(g.pStmt, 1, x1); speedtest1_run(); } speedtest1_end_test(); } /* ** A testset used for debugging speedtest1 itself. */ void testset_debug1(void){ unsigned i, n; unsigned x1, x2; |
︙ | ︙ | |||
1606 1607 1608 1609 1610 1611 1612 1613 1614 1615 1616 1617 1618 1619 | } if( g.bExplain ) printf(".explain\n.echo on\n"); if( strcmp(zTSet,"main")==0 ){ testset_main(); }else if( strcmp(zTSet,"debug1")==0 ){ testset_debug1(); }else if( strcmp(zTSet,"cte")==0 ){ testset_cte(); }else if( strcmp(zTSet,"rtree")==0 ){ #ifdef SQLITE_ENABLE_RTREE testset_rtree(6, 147); #else fatal_error("compile with -DSQLITE_ENABLE_RTREE to enable " | > > | 1875 1876 1877 1878 1879 1880 1881 1882 1883 1884 1885 1886 1887 1888 1889 1890 | } if( g.bExplain ) printf(".explain\n.echo on\n"); if( strcmp(zTSet,"main")==0 ){ testset_main(); }else if( strcmp(zTSet,"debug1")==0 ){ testset_debug1(); }else if( strcmp(zTSet,"orm")==0 ){ testset_orm(); }else if( strcmp(zTSet,"cte")==0 ){ testset_cte(); }else if( strcmp(zTSet,"rtree")==0 ){ #ifdef SQLITE_ENABLE_RTREE testset_rtree(6, 147); #else fatal_error("compile with -DSQLITE_ENABLE_RTREE to enable " |
︙ | ︙ |