WordPress.org
Get WordPress

Make WordPress Core

Ticket #24044: wp_options_test_index_options.results

File wp_options_test_index_options.results, 4.1 KB (added by jrchamp, 10 years ago)

Test results for MyISAM and InnoDB. Single column index appears to be better.

Line 
1MyISAM - Size 300 - Percent 80
2
3MyISAM - Size 300 - Percent 50
4
5MyISAM - Size 300 - Percent 20
6
7MyISAM - Size 300 - Percent 5
8
9MyISAM - Size 3000 - Percent 80
10
11MyISAM - Size 3000 - Percent 50
12
13MyISAM - Size 3000 - Percent 20
14
15MyISAM - Size 3000 - Percent 5
16
17MyISAM - Size 30000 - Percent 80
18VARCHAR20_idx 'yes' 0.32887 << Slower 94%
19ENUM_idx 'yes' 0.18603 >> Faster 165%
20CHAR1_idx 'y' 0.16231 >> Faster 189%
21TINYINT_idx 1 0.24030 >> Faster 128%
22VARCHAR20_idx2 'yes' 0.25805 >> Faster 119%
23
24MyISAM - Size 30000 - Percent 50
25VARCHAR20_idx 'yes' 0.14539 << Slower 77%
26ENUM_idx 'yes' 0.16965 << Slower 66%
27CHAR1_idx 'y' 0.13699 << Slower 82%
28TINYINT_idx 1 0.17453 << Slower 64%
29VARCHAR20_idx2 'yes' 0.18912 << Slower 59%
30
31MyISAM - Size 30000 - Percent 20
32VARCHAR20_idx 'yes' 0.04939 >> Faster 230%
33ENUM_idx 'yes' 0.06797 >> Faster 167%
34CHAR1_idx 'y' 0.06049 >> Faster 188%
35TINYINT_idx 1 0.04118 >> Faster 276%
36VARCHAR20_idx2 'yes' 0.08665 >> Faster 131%
37
38MyISAM - Size 30000 - Percent 5
39VARCHAR20_idx 'yes' 0.02290 >> Faster 192%
40ENUM_idx 'yes' 0.01579 >> Faster 279%
41CHAR1_idx 'y' 0.02124 >> Faster 207%
42TINYINT_idx 1 0.02212 >> Faster 199%
43VARCHAR20_idx2 'yes' 0.02274 >> Faster 194%
44
45MyISAM - Size 300000 - Percent 80
46VARCHAR20_idx 'yes' 13.91944 >> Faster 114%
47ENUM_idx 'yes' 13.57117 >> Faster 117%
48CHAR1_idx 'y' 13.48627 >> Faster 118%
49TINYINT_idx 1 13.95263 >> Faster 114%
50VARCHAR20_idx2 'yes' 14.20898 >> Faster 112%
51
52MyISAM - Size 300000 - Percent 50
53VARCHAR20_idx 'yes' 3.53647 >> Faster 115%
54ENUM_idx 'yes' 3.63556 >> Faster 112%
55CHAR1_idx 'y' 3.79593 >> Faster 108%
56TINYINT_idx 1 3.74577 >> Faster 109%
57VARCHAR20_idx2 'yes' 3.60516 >> Faster 113%
58
59MyISAM - Size 300000 - Percent 20
60VARCHAR20_idx 'yes' 0.65351 >> Faster 111%
61ENUM_idx 'yes' 0.59216 >> Faster 123%
62CHAR1_idx 'y' 0.29596 >> Faster 246%
63TINYINT_idx 1 0.26829 >> Faster 271%
64VARCHAR20_idx2 'yes' 0.61947 >> Faster 117%
65
66MyISAM - Size 300000 - Percent 5
67VARCHAR20_idx 'yes' 0.20180 >> Faster 224%
68ENUM_idx 'yes' 0.19219 >> Faster 235%
69CHAR1_idx 'y' 0.18934 >> Faster 239%
70TINYINT_idx 1 0.13178 >> Faster 343%
71VARCHAR20_idx2 'yes' 0.18153 >> Faster 249%
72
73InnoDB - Size 300 - Percent 80
74
75InnoDB - Size 300 - Percent 50
76
77InnoDB - Size 300 - Percent 20
78
79InnoDB - Size 300 - Percent 5
80
81InnoDB - Size 3000 - Percent 80
82
83InnoDB - Size 3000 - Percent 50
84
85InnoDB - Size 3000 - Percent 20
86
87InnoDB - Size 3000 - Percent 5
88
89InnoDB - Size 30000 - Percent 80
90VARCHAR20_idx 'yes' 0.29857 << Slower 83%
91ENUM_idx 'yes' 0.37153 << Slower 67%
92CHAR1_idx 'y' 0.19721 >> Faster 126%
93TINYINT_idx 1 0.35160 << Slower 71%
94VARCHAR20_idx2 'yes' 0.36607 << Slower 68%
95
96InnoDB - Size 30000 - Percent 50
97VARCHAR20_idx 'yes' 0.21720 >> Faster 106%
98ENUM_idx 'yes' 0.18135 >> Faster 127%
99CHAR1_idx 'y' 0.21803 >> Faster 106%
100VARCHAR20_idx2 'yes' 0.15909 >> Faster 145%
101
102InnoDB - Size 30000 - Percent 20
103VARCHAR20_idx 'yes' 0.07345 >> Faster 154%
104ENUM_idx 'yes' 0.08401 >> Faster 135%
105CHAR1_idx 'y' 0.09080 >> Faster 125%
106TINYINT_idx 1 0.09002 >> Faster 126%
107VARCHAR20_idx2 'yes' 0.07047 >> Faster 161%
108
109InnoDB - Size 30000 - Percent 5
110VARCHAR20_idx 'yes' 0.01746 >> Faster 442%
111ENUM_idx 'yes' 0.01764 >> Faster 438%
112CHAR1_idx 'y' 0.01803 >> Faster 429%
113TINYINT_idx 1 0.01771 >> Faster 436%
114VARCHAR20_idx2 'yes' 0.02453 >> Faster 315%
115
116InnoDB - Size 300000 - Percent 80
117VARCHAR20_idx 'yes' 16.59574 << Slower 85%
118ENUM_idx 'yes' 19.08893 << Slower 74%
119CHAR1_idx 'y' 6.15150 >> Faster 228%
120TINYINT_idx 1 6.03255 >> Faster 233%
121VARCHAR20_idx2 'yes' 16.59940 << Slower 85%
122
123InnoDB - Size 300000 - Percent 50
124VARCHAR20_idx 'yes' 1.83079 >> Faster 265%
125ENUM_idx 'yes' 1.84787 >> Faster 263%
126CHAR1_idx 'y' 3.20020 >> Faster 152%
127TINYINT_idx 1 5.28905 << Slower 92%
128VARCHAR20_idx2 'yes' 3.59981 >> Faster 135%
129
130InnoDB - Size 300000 - Percent 20
131VARCHAR20_idx 'yes' 0.31656 >> Faster 449%
132ENUM_idx 'yes' 0.75162 >> Faster 189%
133CHAR1_idx 'y' 0.54011 >> Faster 263%
134TINYINT_idx 1 0.52870 >> Faster 269%
135VARCHAR20_idx2 'yes' 0.70546 >> Faster 202%
136
137InnoDB - Size 300000 - Percent 5
138VARCHAR20_idx 'yes' 0.08515 >> Faster 1,605%
139ENUM_idx 'yes' 0.07764 >> Faster 1,760%
140CHAR1_idx 'y' 0.13843 >> Faster 987%
141TINYINT_idx 1 0.17501 >> Faster 781%
142VARCHAR20_idx2 'yes' 0.25953 >> Faster 527%
143