SQLite Speedtest

This is a benchmark of SQLite's speedtest1 benchmark program with an increased problem size of 1,000.


SQLite Speedtest 3.30

Timed Time - Size 1,000

OpenBenchmarking.org metrics for this test profile configuration based on 4,019 public results since 7 October 2019 with the latest data as of 21 December 2024.

Below is an overview of the generalized performance for components where there is sufficient statistically significant data based upon user-uploaded results. It is important to keep in mind particularly in the Linux/open-source space there can be vastly different OS configurations, with this overview intended to offer just general guidance as to the performance expectations.

Component
Details
Percentile Rank
# Compatible Public Results
Seconds (Average)
Raptor Lake [24 Cores / 32 Threads]
100th
8
31
Raptor Lake [24 Cores / 32 Threads]
100th
48
32 +/- 1
Zen 5 [96 Cores / 192 Threads]
98th
10
34 +/- 1
Raptor Lake [14 Cores / 20 Threads]
98th
5
34
Raptor Lake [14 Cores / 20 Threads]
95th
12
37
Raptor Lake [14 Cores / 20 Threads]
95th
7
37
Zen 4 [16 Cores / 32 Threads]
95th
41
37 +/- 4
Zen 4 [8 Cores / 16 Threads]
94th
18
37 +/- 5
Alder Lake [10 Cores / 16 Threads]
94th
13
38
Zen 4 [16 Cores / 32 Threads]
94th
20
38 +/- 6
Zen 4 [6 Cores / 12 Threads]
94th
16
39 +/- 5
Zen 4 [12 Cores / 24 Threads]
94th
14
39 +/- 5
Raptor Lake [4 Cores / 8 Threads]
93rd
6
40
Rocket Lake [8 Cores / 16 Threads]
93rd
4
40
Raptor Lake [10 Cores / 16 Threads]
92nd
4
42
Alder Lake [6 Cores / 12 Threads]
92nd
7
42 +/- 1
Zen 4 [12 Cores / 24 Threads]
89th
8
43 +/- 5
Zen 3 [16 Cores / 32 Threads]
89th
140
43 +/- 3
Rocket Lake [8 Cores / 16 Threads]
89th
12
43 +/- 1
Zen 4 [8 Cores / 16 Threads]
88th
5
43 +/- 4
Zen 3 [6 Cores / 12 Threads]
88th
24
43 +/- 1
Meteor Lake [16 Cores / 22 Threads]
87th
7
44
Zen 3 [8 Cores / 16 Threads]
87th
41
44 +/- 3
Alder Lake [4 Cores / 8 Threads]
87th
3
44
Tiger Lake [8 Cores / 16 Threads]
86th
3
44
Zen 3 [8 Cores / 16 Threads]
86th
11
44 +/- 1
[8 Cores / 16 Threads]
86th
4
44 +/- 1
Zen 4 [12 Cores / 24 Threads]
85th
5
45 +/- 5
Rocket Lake [8 Cores / 16 Threads]
85th
71
45 +/- 3
Rocket Lake [6 Cores / 12 Threads]
84th
4
46 +/- 1
Comet Lake [10 Cores / 20 Threads]
83rd
45
46 +/- 1
Comet Lake [10 Cores / 20 Threads]
82nd
8
47 +/- 1
Kaby/Coffee/Whiskey Lake [8 Cores / 16 Threads]
80th
14
48 +/- 1
Kaby/Coffee/Whiskey Lake [8 Cores / 16 Threads]
80th
5
48
[4 Cores / 8 Threads]
80th
5
48 +/- 5
Tiger Lake [8 Cores / 16 Threads]
79th
4
49 +/- 3
Zen 4 [8 Cores / 16 Threads]
79th
11
49
Zen 4 [6 Cores / 12 Threads]
78th
11
49
Kaby/Coffee/Whiskey Lake [8 Cores / 16 Threads]
78th
10
50 +/- 1
Zen 3 [8 Cores / 16 Threads]
78th
4
50 +/- 1
Zen 4 [8 Cores / 16 Threads]
78th
3
50 +/- 2
Zen 4 [8 Cores / 16 Threads]
78th
4
50 +/- 5
Kaby/Coffee/Whiskey Lake [8 Cores / 16 Threads]
78th
21
50 +/- 4
Comet Lake [6 Cores / 12 Threads]
78th
10
50 +/- 1
Comet Lake [8 Cores / 16 Threads]
78th
7
50 +/- 1
Zen 3 [8 Cores / 16 Threads]
77th
15
50 +/- 3
Mid-Tier
75th
> 52
Tiger Lake [4 Cores / 8 Threads]
75th
20
52 +/- 2
Zen 3 [64 Cores / 128 Threads]
75th
5
52 +/- 1
Zen 3 [8 Cores / 16 Threads]
74th
27
53 +/- 3
Zen 4 [8 Cores / 16 Threads]
73rd
3
53 +/- 1
Zen 3 [6 Cores / 12 Threads]
73rd
3
54 +/- 1
Sapphire Rapids [60 Cores / 120 Threads]
72nd
4
54
Kaby/Coffee/Whiskey Lake [6 Cores / 12 Threads]
71st
4
55 +/- 2
Zen 2 [8 Cores / 16 Threads]
71st
5
55 +/- 2
Tiger Lake [4 Cores / 8 Threads]
70th
65
55 +/- 8
Zen 3 [32 Cores / 64 Threads]
70th
23
56 +/- 4
Zen 3 [8 Cores / 16 Threads]
69th
14
56 +/- 7
Zen 2 [12 Cores / 24 Threads]
68th
11
56 +/- 1
Comet Lake [4 Cores / 8 Threads]
68th
11
56 +/- 1
Zen 2 [6 Cores / 12 Threads]
67th
7
57 +/- 2
Zen 3 [24 Cores / 48 Threads]
67th
6
57 +/- 7
Kaby/Coffee/Whiskey Lake [8 Cores / 8 Threads]
66th
4
57 +/- 6
Zen 2 [32 Cores / 64 Threads]
66th
46
57 +/- 1
Zen 2 [4 Cores / 8 Threads]
65th
8
58
Kaby/Coffee/Whiskey Lake [6 Cores / 12 Threads]
65th
13
58 +/- 7
Zen 2 [8 Cores / 16 Threads]
65th
20
58 +/- 2
Zen 2 [12 Cores / 24 Threads]
64th
30
58 +/- 4
Zen 3 [128 Cores / 256 Threads]
64th
17
58 +/- 2
Zen 2 [24 Cores / 48 Threads]
64th
19
58 +/- 2
Zen 2 [8 Cores / 16 Threads]
64th
3
59
[12 Cores / 24 Threads]
63rd
3
59
Zen 2 [8 Cores / 16 Threads]
63rd
4
59 +/- 1
Zen 2 [6 Cores / 12 Threads]
63rd
7
59 +/- 2
Ice Lake [4 Cores / 8 Threads]
60th
31
61 +/- 6
Zen 3 [56 Cores / 112 Threads]
60th
3
61 +/- 1
Ice Lake [80 Cores / 160 Threads]
60th
22
61 +/- 2
Kaby/Coffee/Whiskey Lake [8 Cores / 8 Threads]
60th
3
61 +/- 1
Zen 2 [16 Cores / 32 Threads]
59th
3
62 +/- 2
Zen 3 [6 Cores / 12 Threads]
59th
5
62 +/- 3
Zen 2 [6 Cores / 12 Threads]
59th
3
62
Cascade Lake [18 Cores / 36 Threads]
57th
26
63 +/- 3
[40 Cores / 80 Threads]
56th
3
64 +/- 1
Cascade Lake [16 Cores / 32 Threads]
56th
23
64 +/- 2
Cascade Lake [20 Cores / 20 Threads]
56th
4
64
Kaby/Coffee/Whiskey Lake [6 Cores / 12 Threads]
55th
18
65 +/- 5
Zen 2 [64 Cores / 128 Threads]
55th
63
65 +/- 7
Cascade Lake [12 Cores / 24 Threads]
53rd
8
66 +/- 4
Comet Lake [2 Cores / 4 Threads]
53rd
6
66 +/- 1
Kaby/Coffee/Whiskey Lake [6 Cores / 6 Threads]
53rd
10
66 +/- 6
Zen 4 [8 Cores / 16 Threads]
53rd
4
66 +/- 4
Kaby/Coffee/Whiskey Lake [4 Cores / 8 Threads]
53rd
4
66 +/- 10
Cascade Lake [16 Cores / 32 Threads]
53rd
6
66 +/- 2
Cascade Lake [56 Cores / 112 Threads]
53rd
36
66 +/- 2
Cascade Lake [36 Cores / 72 Threads]
52nd
5
67 +/- 1
Zen 2 [8 Cores / 16 Threads]
52nd
10
67
Cascade Lake [48 Cores / 96 Threads]
52nd
13
67 +/- 2
Zen+ [6 Cores / 12 Threads]
51st
5
68
Cascade Lake [16 Cores / 32 Threads]
51st
7
68 +/- 2
Kaby/Coffee/Whiskey Lake [4 Cores / 8 Threads]
51st
6
68 +/- 5
Zen+ [32 Cores / 64 Threads]
51st
7
68 +/- 1
Kaby/Coffee/Whiskey Lake [4 Cores / 8 Threads]
51st
13
68 +/- 9
Median
50th
68
Zen+ [24 Cores / 48 Threads]
49th
6
69
Zen+ [16 Cores / 32 Threads]
49th
4
69 +/- 1
Cascade Lake [8 Cores / 16 Threads]
49th
3
69
Cascade Lake [32 Cores / 32 Threads]
47th
3
70 +/- 2
Cascade Lake [8 Cores / 16 Threads]
47th
12
70 +/- 4
Zen 2 [8 Cores / 8 Threads]
47th
14
70 +/- 2
Kaby/Coffee/Whiskey Lake [2 Cores / 8 Threads]
47th
12
70 +/- 3
Kaby/Coffee/Whiskey Lake [6 Cores / 6 Threads]
47th
6
70 +/- 2
Zen 2 [48 Cores / 96 Threads]
47th
8
70
Skylake [8 Cores / 8 Threads]
47th
9
70 +/- 4
Zen 2 [6 Cores / 12 Threads]
47th
29
70 +/- 1
Skylake [8 Cores / 8 Threads]
46th
15
71 +/- 2
Zen 2 [24 Cores / 48 Threads]
46th
14
71 +/- 1
Zen 3 [64 Cores / 128 Threads]
46th
3
71 +/- 1
Cascade Lake [8 Cores / 16 Threads]
46th
5
71 +/- 1
Kaby/Coffee/Whiskey Lake [4 Cores / 4 Threads]
46th
7
71 +/- 2
Zen [8 Cores / 16 Threads]
44th
10
72 +/- 2
Zen+ [12 Cores / 24 Threads]
44th
3
72 +/- 1
Zen 2 [6 Cores / 6 Threads]
44th
30
72 +/- 2
Cascade Lake [12 Cores / 24 Threads]
43rd
3
73
Cascade Lake [48 Cores / 96 Threads]
42nd
20
74 +/- 2
Kaby/Coffee/Whiskey Lake [2 Cores / 8 Threads]
42nd
5
74 +/- 3
Zen+ [8 Cores / 16 Threads]
42nd
16
74 +/- 6
Skylake [8 Cores / 8 Threads]
42nd
11
74 +/- 10
Cascade Lake [40 Cores / 80 Threads]
42nd
3
74 +/- 5
Zen [4 Cores / 8 Threads]
42nd
17
74 +/- 2
Broadwell [8 Cores / 8 Threads]
42nd
7
74 +/- 6
Kaby/Coffee/Whiskey Lake [4 Cores / 8 Threads]
41st
3
75 +/- 1
Haswell [4 Cores / 8 Threads]
41st
3
75
Zen 2 [32 Cores / 64 Threads]
41st
5
75 +/- 1
Kaby/Coffee/Whiskey Lake [6 Cores / 12 Threads]
41st
19
75 +/- 7
Zen 4 [96 Cores / 192 Threads]
41st
6
75 +/- 1
Skylake [8 Cores / 8 Threads]
41st
3
75 +/- 2
Zen 2 [32 Cores / 64 Threads]
41st
5
75
Zen 4 [96 Cores / 192 Threads]
39th
6
76 +/- 1
Zen 2 [32 Cores / 64 Threads]
39th
9
76 +/- 1
Cascade Lake [40 Cores / 80 Threads]
39th
15
76 +/- 9
Cascade Lake [16 Cores / 32 Threads]
39th
7
76 +/- 2
Haswell [8 Cores / 8 Threads]
39th
5
76 +/- 7
Zen 2 [24 Cores / 48 Threads]
39th
8
76 +/- 2
Zen 2 [8 Cores / 16 Threads]
39th
3
76
Zen 2 [48 Cores / 96 Threads]
37th
21
77 +/- 1
Alder Lake [4 Cores / 4 Threads]
37th
5
77 +/- 2
Zen 2 [64 Cores / 128 Threads]
37th
6
77
Zen 2 [48 Cores / 96 Threads]
37th
6
77 +/- 1
Zen 2 [128 Cores / 256 Threads]
37th
16
77 +/- 2
Zen 2 [32 Cores / 64 Threads]
37th
6
77
Zen 2 [8 Cores / 16 Threads]
37th
11
77 +/- 3
Kaby/Coffee/Whiskey Lake [4 Cores / 4 Threads]
37th
9
77 +/- 5
Kaby/Coffee/Whiskey Lake [4 Cores / 8 Threads]
37th
13
77 +/- 8
Zen 2 [64 Cores / 128 Threads]
36th
20
78 +/- 1
Zen 2 [96 Cores / 192 Threads]
36th
3
78
Zen+ [6 Cores / 12 Threads]
36th
3
78 +/- 3
Zen 2 [32 Cores / 64 Threads]
36th
11
78 +/- 4
Zen 2 [16 Cores / 32 Threads]
36th
6
78 +/- 1
Zen 2 [16 Cores / 32 Threads]
36th
7
78 +/- 5
Skylake [4 Cores / 8 Threads]
35th
5
79 +/- 8
Cascade Lake [48 Cores / 96 Threads]
35th
20
79 +/- 1
Zen 2 [8 Cores / 16 Threads]
35th
3
79
Haswell [4 Cores / 4 Threads]
35th
8
79 +/- 1
Broadwell [12 Cores / 12 Threads]
35th
7
79 +/- 1
Zen 2 [12 Cores / 24 Threads]
35th
4
79 +/- 1
Zen [4 Cores / 4 Threads]
35th
4
79
Haswell [16 Cores / 16 Threads]
35th
3
79
Zen [4 Cores / 8 Threads]
35th
7
79 +/- 2
Zen [4 Cores / 8 Threads]
33rd
6
80
Zen 2 [24 Cores / 48 Threads]
33rd
7
80 +/- 1
Zen 2 [8 Cores / 16 Threads]
33rd
6
80 +/- 1
Zen [4 Cores / 4 Threads]
31st
6
81 +/- 2
Skylake [8 Cores / 8 Threads]
31st
3
81 +/- 10
Kaby/Coffee/Whiskey Lake [2 Cores / 4 Threads]
31st
6
81 +/- 12
Zen [8 Cores / 16 Threads]
31st
12
82 +/- 5
Comet Lake [2 Cores / 2 Threads]
30th
6
83 +/- 1
Haswell [4 Cores / 4 Threads]
30th
4
83
Haswell [20 Cores / 20 Threads]
30th
3
83 +/- 9
Haswell [16 Cores / 16 Threads]
29th
15
85 +/- 2
Zen [32 Cores / 64 Threads]
27th
7
90 +/- 1
Zen [64 Cores / 128 Threads]
26th
9
91 +/- 3
Skylake [4 Cores / 4 Threads]
26th
22
91 +/- 11
Zen 4 [128 Cores / 256 Threads]
26th
6
91 +/- 1
Cascade Lake [8 Cores / 16 Threads]
26th
3
92
Sandy Bridge [4 Cores / 8 Threads]
26th
19
92 +/- 8
Cascade Lake [24 Cores / 48 Threads]
26th
4
93 +/- 9
Low-Tier
25th
> 93
Zen [2 Cores / 4 Threads]
25th
13
94 +/- 4
Broadwell [4 Cores / 4 Threads]
24th
7
96 +/- 1
Cascade Lake [24 Cores / 48 Threads]
24th
4
97 +/- 1
Ivy Bridge [8 Cores / 8 Threads]
23rd
4
98 +/- 3
Zen 4 [64 Cores / 128 Threads]
23rd
3
99 +/- 1
Skylake [8 Cores / 8 Threads]
23rd
9
100 +/- 13
Ivy Bridge [4 Cores / 4 Threads]
22nd
3
101
Haswell [4 Cores / 4 Threads]
22nd
7
103 +/- 1
Haswell [4 Cores / 4 Threads]
20th
4
107 +/- 8
Westmere [12 Cores / 12 Threads]
20th
9
109 +/- 5
Skylake [4 Cores / 8 Threads]
18th
12
117 +/- 1
Skylake [4 Cores / 4 Threads]
18th
5
119 +/- 10
Bulldozer [8 Cores / 8 Threads]
17th
4
122
Ivy Bridge [4 Cores / 4 Threads]
16th
5
124 +/- 1
Haswell [4 Cores / 4 Threads]
16th
7
125 +/- 15
Shanghai [4 Cores / 4 Threads]
16th
6
129 +/- 3
[2 Cores / 4 Threads]
15th
3
130 +/- 1
Bulldozer [8 Cores / 8 Threads]
15th
4
131 +/- 2
Steamroller [2 Cores / 4 Threads]
14th
7
141 +/- 4
Kaby/Coffee/Whiskey Lake [2 Cores / 4 Threads]
14th
5
143 +/- 5
Sandy Bridge [4 Cores / 4 Threads]
13th
3
145 +/- 1
Ivy Bridge [12 Cores / 24 Threads]
13th
37
146 +/- 2
Broadwell [2 Cores / 4 Threads]
12th
11
151 +/- 1
Broadwell [8 Cores / 8 Threads]
11th
3
160
Sandy Bridge [16 Cores / 32 Threads]
11th
18
161 +/- 21
10th
9
165 +/- 2
10th
15
170 +/- 1
Haswell [2 Cores / 4 Threads]
10th
3
175 +/- 12
Excavator [2 Cores / 4 Threads]
7th
4
260 +/- 9
Prescott [2 Cores / 2 Threads]
5th
10
454 +/- 53
Ontaro [2 Cores / 2 Threads]
5th
3
472 +/- 1
Airmont [4 Cores / 4 Threads]
4th
6
503 +/- 55
3rd
4
613 +/- 27
Ivy Bridge [4 Cores / 4 Threads]
1st
5
788 +/- 6