SQLite [pts/sqlite]

Showing composite data for the trailing 3 years for the pts/sqlite test profile of all disk components where there are at least 10 results with systems having the listed component. The standard error is reported for the difference in performance against all available data. For test profiles where multiple options/versions are available, the most popular result combinations are listed first. This data is based upon 8,890 results.

Limit Resuls To Hardware/Software Matches:

12,500 INSERTs

OpenBenchmarking.orgSeconds, Less Is BetterSQLite v3.7.3OpenBenchmarking.org Stats: 12,500 INSERTsPERC H730PMR9361-8iMR9265-8iMR9266-8iSMC2208PERC H710PINTEL SSDSC2BB12INTEL SSDSC2BB24RS2BL080VVVMware Virtual S500GBLinux Testgel ndiSCSI StorageSanDisk SDSSDXP4Samsung SSD 850SDW16GVirtual diskLOGICAL VOLUMEKINGSTON RBU-SNSSanDisk SDSSDXPSVBOX HDDSanDisk SDSSDP06ServeRAID M1015SanDisk SSD U100Crucial_CT256MX1Fordisk S860 64GSMC2108OCZ SOLID_SSDADATA SP600KINGSTON SV300S3Samsung SSD 840IPR-10 E8A26D57Crucial_CT120M50INTEL SSDSC2BW24IPR-10 0C420D1B00BEKT-00PVMT0Seagate ST240HM000Western Digital WD3200BPVT-2Western Digital WD20EFRX-68E00000Virtual DiskWestern Digital WD3200AAKS-7Western Digital WD1003FZEX-0Seagate ST340014ASeagate ST2000DM001-1CH1Seagate ST380011ASeagate ST1000NM0033-9ZMWestern Digital WD3200AAKX-0QEMU HDDLogical VolumeSeagate ST3250410ASWestern Digital WD3200BEKT-0Western Digital WD30EFRX-68ASeagate ST1000DX001-1CM1Western Digital WD30EFRX-68EWestern Digital WD2500AAJS-0FUJITSU MHY2120BSeagate ST500DM002-1BD14Seagate ST3250310ASHitachi HTS54505Seagate ST1000DM003-1CH1Western Digital WD800JD-60LSFUJITSU MHZ2250BWestern Digital WD40PURX-64GSeagate ST3500418AS5001000150020002500SE +/- 0.79SE +/- 0.35SE +/- 0.09SE +/- 0.18SE +/- 0.33SE +/- 5.03SE +/- 0.19SE +/- 0.00SE +/- 0.10SE +/- 2.02SE +/- 8.21SE +/- 6.03SE +/- 2.99SE +/- 2.05SE +/- 0.02SE +/- 2.89SE +/- 5.17SE +/- 8.30SE +/- 30.58SE +/- 6.63SE +/- 18.78SE +/- 23.38SE +/- 12.74SE +/- 95.04SE +/- 0.35SE +/- 59.94SE +/- 1.03SE +/- 259.04SE +/- 6.74SE +/- 36.31SE +/- 88.04SE +/- 49.12SE +/- 3.22SE +/- 0.69SE +/- 36.83SE +/- 3.45SE +/- 23.89SE +/- 172.50SE +/- 64.62SE +/- 59.82SE +/- 12.74SE +/- 147.62SE +/- 194.73SE +/- 261.04SE +/- 132.34SE +/- 127.91SE +/- 78.21SE +/- 232.19SE +/- 78.97SE +/- 690.30SE +/- 338.85SE +/- 131.47SE +/- 0.00SE +/- 93.74SE +/- 110.88SE +/- 0.00SE +/- 0.00SE +/- 62.38SE +/- 381.29SE +/- 131.04SE +/- 210.13SE +/- 110.39SE +/- 416.76SE +/- 134.96SE +/- 23.38SE +/- 98.085.618.899.4810.2711.2817.2918.1921.2522.7725.7226.4329.9835.7153.9164.6170.6872.7174.7486.63126.86132.02132.68157.52187.86197.05255.98259.11276.21288.28288.62312.2369.1434.11465.47477.71507.54523.55659.62664.58725.74813.95824.65893.15919.61948.2962.57990.371115.491191.671208.391229.341261.621348.471435.981477.421507.461518.131569.541708.971752.161765.591898.111920.692003.632170.662317.26Phoronix Test Suite 6.4.0

Test Target: Default Test Directory

OpenBenchmarking.orgSeconds, Less Is BetterSQLite v3.7.3OpenBenchmarking.org Stats: Test Target: Default Test DirectorySMC3108PERC H710PC50HGST HTS545032A7SMC2108KINGSTON SH103S3SanDisk SDSSDXP4VMware Virtual ICrucial_CT250MX2GOODRAM C50VMware Virtual SINTEL SSDSC2CT12Virtual diskSamsung SSD 850LOGICAL VOLUMEINTEL SSDSA2CT04VBOX HDDSAMSUNG SSD PM8500000Samsung SSD 840Western Digital WDC WD5000AAKX-0IPR-10 E8A26D57Seagate ST1000NM0033-9ZMIPR-10 0C420D1BSeagate ST1000DM003-1CH1Logical VolumeKINGSTON SV300S3Western Digital WD5003ABYX-000BEVT-22A23T0Seagate ST3120813ASWestern Digital WD1600AAJB-2Hitachi HCC54755Seagate ST500DM002-1BD14Maxtor 6E040T0400800120016002000SE +/- 0.60SE +/- 0.28SE +/- 0.00SE +/- 0.12SE +/- 0.00SE +/- 0.03SE +/- 1.18SE +/- 18.34SE +/- 19.40SE +/- 11.95SE +/- 3.57SE +/- 36.77SE +/- 3.48SE +/- 4.79SE +/- 49.11SE +/- 2.18SE +/- 4.96SE +/- 0.13SE +/- 12.18SE +/- 174.77SE +/- 158.63SE +/- 1.05SE +/- 230.12SE +/- 1.45SE +/- 276.56SE +/- 420.12SE +/- 206.87SE +/- 17.68SE +/- 0.00SE +/- 384.25SE +/- 0.00SE +/- 8.03SE +/- 307.88SE +/- 39.998.1110.5819.5819.6121.830.9963.7375.1981.0290.2294.9195.9196.599.71119.1120.85125.17171.92347.14388.77397.46426.92469.43500.43546.56558.31576.37716.69850.9893.591178.941637.621651.791838.8Phoronix Test Suite 6.4.0

Test Target: Default Test Directory

OpenBenchmarking.orgSeconds, Less Is BetterSQLite v3.8.10.2OpenBenchmarking.org Stats: Test Target: Default Test Directory480GB MRADATA SSD S510 6INTEL SSDSC2CT12Samsung SSD 850 EVO 120GB EMT01B6QSL32GINTEL SSDPEKKW256G7VMware Virtual SVolumeSATA PNY CS1211 120GB CS12INTEL SSDSA2M160APPLE SSD SD0128PersistentDiskSanDisk SD6SP1M1Western Digital WDS250G1B0A-VisionTekOCZ TRION100OCZ TRION150Samsung SSD 960 EVOPNY CS1211 120GB SSD 754D117-483 CS121101SanDisk SDSSDP06Samsung SSD 850SanDisk SD5SF2121 TB APPLE HDD HTS541010A9E662Seagate ST2000DX001-1NS1ADATA SP800SPCC Solid StateCrucial_CT250MX2TS256GSSD370VBOX HDDCrucial_CT500MX2SanDisk SDSSDA12Samsung SSD 960 PRO 1TBTS256GSSD370SSamsung SSD 950 PROTOSHIBA-TR150TOSHIBA THNSNH12Hitachi HTS54505Seagate ST31500341ASCT120BX100SSD1OCZ VECTOR150SAMSUNG HD502HJOCZ CORE_SSDWestern Digital WD10EZEX-00RPNY CS1211CORSAIR FORCE LXSE32GKINGSTON SV300S3OCZ ARC100SL16G00000SATA FlashSAMSUNG SSD 830Micron_M500_MTFDSeagate ST500LM000-SSHD-Crucial_CT256MX1SD16GSamsung SSD 840QEMU HDDNCardSeagate ST914603SSUN146G00AAKS-22A7B2SATA SSDSD08GINTEL SSDSCKGW080A4 DC01AGND3RWestern Digital WD10EZRX-00ASeagate ST3300622ASINTEL SSDSC2BW12Crucial_CT128MX1Virtual DiskINTEL SSDSCKGW08Western Digital WD10EZEX-00KSeagate ST3500413ASSeagate ST3320620ASWestern Digital WD5000BEKT-8HGST HTS721010A9Hitachi HUA72302HGST HTS545050A7Seagate ST9160821ASSeagate ST2000DL003-9VT1Seagate ST980811ASSeagate ST2000DM001-1CH1Seagate ST500DM002-1BD14120GB ToshibaWestern Digital WD1500HLHX-0Western Digital WD5000AZRX-0Seagate ST1000DX001-1CM1Western Digital WD5000AAKX-0OCZ VERTEX3SAMSUNG SP2504CSeagate ST2000DM001-1E61SAMSUNG HD253GJSeagate ST3250310ASWestern Digital WD10EARS-00MTOSHIBA MQ01ABD12004006008001000SE +/- 0.20SE +/- 0.04SE +/- 0.04SE +/- 0.81SE +/- 7.06SE +/- 0.64SE +/- 5.14SE +/- 0.00SE +/- 0.00SE +/- 0.79SE +/- 0.32SE +/- 1.10SE +/- 0.39SE +/- 0.00SE +/- 0.00SE +/- 0.29SE +/- 0.53SE +/- 0.00SE +/- 0.42SE +/- 0.12SE +/- 4.35SE +/- 1.09SE +/- 1.03SE +/- 0.10SE +/- 4.25SE +/- 0.01SE +/- 1.61SE +/- 0.05SE +/- 4.33SE +/- 0.46SE +/- 6.57SE +/- 0.49SE +/- 1.33SE +/- 1.45SE +/- 10.74SE +/- 0.55SE +/- 0.96SE +/- 63.59SE +/- 3.08SE +/- 2.25SE +/- 22.12SE +/- 0.08SE +/- 0.68SE +/- 9.47SE +/- 4.23SE +/- 0.36SE +/- 11.55SE +/- 0.62SE +/- 25.09SE +/- 42.60SE +/- 0.22SE +/- 3.51SE +/- 1.45SE +/- 45.57SE +/- 3.75SE +/- 5.10SE +/- 12.35SE +/- 72.14SE +/- 39.28SE +/- 1.18SE +/- 24.27SE +/- 117.17SE +/- 3.65SE +/- 0.94SE +/- 24.09SE +/- 1.01SE +/- 12.20SE +/- 9.20SE +/- 1.79SE +/- 37.48SE +/- 2.53SE +/- 1.82SE +/- 14.68SE +/- 0.00SE +/- 5.22SE +/- 3.63SE +/- 39.96SE +/- 0.00SE +/- 4.91SE +/- 96.14SE +/- 17.90SE +/- 26.38SE +/- 24.64SE +/- 26.21SE +/- 0.00SE +/- 0.00SE +/- 2.20SE +/- 5.02SE +/- 148.79SE +/- 0.00SE +/- 0.00SE +/- 14.94SE +/- 27.58SE +/- 7.16SE +/- 0.008.6914.1414.4719.7620.0421.3124.1524.7325.4125.7926.8527.1127.8629.8431.0533.9435.6536.5240.8643.6346.0746.0946.549.855455.8557.1458.3262.6663.0164.464.6165.4668.7671.0375.1378.5581.3481.49394.1797.22110.97111.39117.02119.55125.65130.63131.19136.39137.24138.63143.46162.69164.12224.66234.8250.34254.39257.22264.08268.17276.78281.85331.13335.03344.07351.56355.84365.54373.64408.36429.2444.06472.5473.56477.54489.53499.57503.57504.74514.53536.06557.7590.74618.32625.47630.44651.66659.92662.37720.21739.82805.9834.07Phoronix Test Suite 6.4.0

Timed SQLite Insertions

OpenBenchmarking.orgSeconds, Less Is BetterSQLite v3.8.10.2OpenBenchmarking.org Stats: Timed SQLite Insertions726060ALE610ADATA SP600PERC H730 MiniMR9271-8iBHYVE SATA DISK500 28GB APPLE SSD SM0512FSMC2108121 33GB APPLE SSD SM0128G240GB ToshibaINTEL SSDSC2BB30ADATA SP550SMC2208VMware Virtual SVBOX HDDINTEL SSDSC2BX80PersistentDiskADATA SP920SSPERC H710PERC H700SanDisk SDSSDA24SATA SSDLOGICAL VOLUMEINTEL SSDSC2BB16KINGSTON SUV400SKINGSTON SUV300SSAMSUNG SSD 830PERC H330 MiniADATA SX930TOSHIBA MK3255GSINTEL SSDMCEAC12SanDisk SSD U100Samsung SSD 850OCZ AGILITY3SAMSUNG SSD PM85HGST HDN726060ALOCZ REVODRIVEPRAID CP400iQEMU HDD256GBINTEL SSDSC2BW12Virtual DiskINTEL SSDSCKJW12Virtual diskINTEL SSDSC2BW48Seagate ST4000DX001-1CE1Samsung SSD 840Western Digital WD3000BLFS-6MSSanDisk Ultra IIKINGSTON SV300S32000GB2115Seagate ST6000NM0024-1HTINTEL SSDSCKGW08Seagate ST9160821ASHitachi HDS72102Western Digital WD20EFRX-68EWestern Digital WD30EFRX-68EWestern Digital WD5000LPVX-2Seagate ST3500413ASFUJITSU MHW2160BWestern Digital WD10EZEX-08MWestern Digital WD10EALX-009Seagate ST1000DM003-1ER1Western Digital WD20EARX-00PSeagate ST500LT012-9WS142004006008001000SE +/- 0.00SE +/- 0.53SE +/- 0.77SE +/- 1.90SE +/- 4.76SE +/- 4.49SE +/- 1.39SE +/- 0.00SE +/- 0.05SE +/- 0.27SE +/- 1.73SE +/- 10.13SE +/- 19.58SE +/- 13.34SE +/- 1.96SE +/- 0.79SE +/- 1.31SE +/- 7.73SE +/- 32.62SE +/- 1.17SE +/- 10.00SE +/- 15.34SE +/- 23.40SE +/- 0.75SE +/- 3.85SE +/- 14.05SE +/- 51.49SE +/- 1.23SE +/- 4.47SE +/- 0.76SE +/- 2.33SE +/- 11.45SE +/- 46.69SE +/- 1.92SE +/- 53.42SE +/- 69.70SE +/- 4.77SE +/- 23.37SE +/- 37.23SE +/- 6.81SE +/- 56.95SE +/- 1.31SE +/- 38.52SE +/- 4.98SE +/- 19.16SE +/- 31.75SE +/- 2.11SE +/- 13.95SE +/- 125.85SE +/- 69.02SE +/- 47.78SE +/- 139.10SE +/- 0.62SE +/- 16.65SE +/- 1.54SE +/- 40.15SE +/- 16.50SE +/- 36.53SE +/- 32.10SE +/- 8.53SE +/- 0.00SE +/- 77.55SE +/- 0.00SE +/- 58.37SE +/- 19.63SE +/- 23.045.416.627.2810.5111.3512.9713.1414.9218.6727.8628.7334.0534.1335.7236.4437.0137.1337.2239.4544.7348.5252.3554.557.1757.9461.4565.1267.2776.1682.8285.7290.5692.5993.49120.29137.82139.36144.39152.54164.51169.86170.41174.61176.9253.18265.8274.05276.27327.32339.43359.53371.3432.17442.66498.28526.42535.19545.78633.3635.85639.52642.16655.26694.4776.93834.18Phoronix Test Suite 6.4.0