Skip to content
This repository was archived by the owner on Dec 3, 2017. It is now read-only.

Commit 899e114

Browse files
author
noah
committed
Integrated SQLite and C#-SQLite benchmark tests
1 parent 5b577a3 commit 899e114

File tree

2 files changed

+368
-0
lines changed

2 files changed

+368
-0
lines changed

‎Benchmark/Benchmark.csproj‎

Lines changed: 348 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,348 @@
1+
<Project DefaultTargets="Build" xmlns="http://schemas.microsoft.com/developer/msbuild/2003">
2+
<PropertyGroup>
3+
<Configuration Condition=" '$(Configuration)' == '' ">Debug</Configuration>
4+
<Platform Condition=" '$(Platform)' == '' ">AnyCPU</Platform>
5+
<ProductVersion>8.0.50727</ProductVersion>
6+
<SchemaVersion>2.0</SchemaVersion>
7+
<ProjectGuid>{F1653F20-D47D-4F29-8C55-3C835542AF5F}</ProjectGuid>
8+
<OutputType>Exe</OutputType>
9+
<AppDesignerFolder>Properties</AppDesignerFolder>
10+
<RootNamespace>CS_SQLite3</RootNamespace>
11+
<AssemblyName>Benchmark</AssemblyName>
12+
<StartupObject>Benchmark</StartupObject>
13+
</PropertyGroup>
14+
<PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Debug|AnyCPU' ">
15+
<DebugSymbols>true</DebugSymbols>
16+
<DebugType>full</DebugType>
17+
<Optimize>false</Optimize>
18+
<OutputPath>bin\Debug\</OutputPath>
19+
<DefineConstants>DEBUG;NO_TCL NDEBUG DEBUG_CLASS_NONE TRUE WIN32 _MSC_VER SQLITE_ASCII SQLITE_DISABLE_LFS SQLITE_ENABLE_COLUMN_METADATAS SQLITE_ENABLE_OVERSIZE_CELL_CHECK SQLITE_MUTEX_OMIT SQLITE_OMIT_AUTHORIZATION SQLITE_OMIT_GET_TABLE SQLITE_OMIT_INCRBLOB SQLITE_OMIT_LOOKASIDE SQLITE_OMIT_SHARED_CACHE SQLITE_OMIT_UTF16 SQLITE_OMIT_VIRTUALTABLE SQLITE_OS_WIN SQLITE_SYSTEM_MALLOC VDBE_PROFILE_OFF</DefineConstants>
20+
<ErrorReport>prompt</ErrorReport>
21+
<WarningLevel>4</WarningLevel>
22+
<NoWarn>0168 ; 0169; 0414; 0618; 0649</NoWarn>
23+
<PlatformTarget>AnyCPU</PlatformTarget>
24+
</PropertyGroup>
25+
<PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Release|AnyCPU' ">
26+
<DebugType>pdbonly</DebugType>
27+
<Optimize>true</Optimize>
28+
<OutputPath>bin\Release\</OutputPath>
29+
<DefineConstants>NO_TCL NDEBUG DEBUG_CLASS_NONE TRUE WIN32 _MSC_VER SQLITE_ASCII SQLITE_DISABLE_LFS SQLITE_ENABLE_COLUMN_METADATAS SQLITE_ENABLE_OVERSIZE_CELL_CHECK SQLITE_MUTEX_OMIT SQLITE_OMIT_AUTHORIZATION SQLITE_OMIT_GET_TABLE SQLITE_OMIT_INCRBLOB SQLITE_OMIT_LOOKASIDE SQLITE_OMIT_SHARED_CACHE SQLITE_OMIT_UTF16 SQLITE_OMIT_VIRTUALTABLE SQLITE_OS_WIN SQLITE_SYSTEM_MALLOC VDBE_PROFILE_OFF</DefineConstants>
30+
<ErrorReport>prompt</ErrorReport>
31+
<WarningLevel>4</WarningLevel>
32+
<PlatformTarget>x86</PlatformTarget>
33+
</PropertyGroup>
34+
<ItemGroup>
35+
<Reference Include="System" />
36+
<Reference Include="System.Data" />
37+
<Reference Include="System.Data.SQLite, Version=1.0.48.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139, processorArchitecture=x86" />
38+
<Reference Include="System.Xml" />
39+
</ItemGroup>
40+
<ItemGroup>
41+
<Compile Include="..\C#-SQLite\src\alter_c.cs">
42+
<Link>C#-SQLite\alter_c.cs</Link>
43+
</Compile>
44+
<Compile Include="..\C#-SQLite\src\analyze_c.cs">
45+
<Link>C#-SQLite\analyze_c.cs</Link>
46+
</Compile>
47+
<Compile Include="..\C#-SQLite\src\attach_c.cs">
48+
<Link>C#-SQLite\attach_c.cs</Link>
49+
</Compile>
50+
<Compile Include="..\C#-SQLite\src\auth_c.cs">
51+
<Link>C#-SQLite\auth_c.cs</Link>
52+
</Compile>
53+
<Compile Include="..\C#-SQLite\src\backup_c.cs">
54+
<Link>C#-SQLite\backup_c.cs</Link>
55+
</Compile>
56+
<Compile Include="..\C#-SQLite\src\bitvec_c.cs">
57+
<Link>C#-SQLite\bitvec_c.cs</Link>
58+
</Compile>
59+
<Compile Include="..\C#-SQLite\src\btmutex_c.cs">
60+
<Link>C#-SQLite\btmutex_c.cs</Link>
61+
</Compile>
62+
<Compile Include="..\C#-SQLite\src\BtreeInt_h.cs">
63+
<Link>C#-SQLite\BtreeInt_h.cs</Link>
64+
</Compile>
65+
<Compile Include="..\C#-SQLite\src\btree_c.cs">
66+
<Link>C#-SQLite\btree_c.cs</Link>
67+
</Compile>
68+
<Compile Include="..\C#-SQLite\src\Btree_h.cs">
69+
<Link>C#-SQLite\Btree_h.cs</Link>
70+
</Compile>
71+
<Compile Include="..\C#-SQLite\src\build_c.cs">
72+
<Link>C#-SQLite\build_c.cs</Link>
73+
</Compile>
74+
<Compile Include="..\C#-SQLite\src\callback_c.cs">
75+
<Link>C#-SQLite\callback_c.cs</Link>
76+
</Compile>
77+
<Compile Include="..\C#-SQLite\src\complete_c.cs">
78+
<Link>C#-SQLite\complete_c.cs</Link>
79+
</Compile>
80+
<Compile Include="..\C#-SQLite\src\date_c.cs">
81+
<Link>C#-SQLite\date_c.cs</Link>
82+
</Compile>
83+
<Compile Include="..\C#-SQLite\src\Delagates.cs">
84+
<Link>C#-SQLite\Delagates.cs</Link>
85+
</Compile>
86+
<Compile Include="..\C#-SQLite\src\delete_c.cs">
87+
<Link>C#-SQLite\delete_c.cs</Link>
88+
</Compile>
89+
<Compile Include="..\C#-SQLite\src\expr_c.cs">
90+
<Link>C#-SQLite\expr_c.cs</Link>
91+
</Compile>
92+
<Compile Include="..\C#-SQLite\src\fault_c.cs">
93+
<Link>C#-SQLite\fault_c.cs</Link>
94+
</Compile>
95+
<Compile Include="..\C#-SQLite\src\func_c.cs">
96+
<Link>C#-SQLite\func_c.cs</Link>
97+
</Compile>
98+
<Compile Include="..\C#-SQLite\src\global_c.cs">
99+
<Link>C#-SQLite\global_c.cs</Link>
100+
</Compile>
101+
<Compile Include="..\C#-SQLite\src\hash_c.cs">
102+
<Link>C#-SQLite\hash_c.cs</Link>
103+
</Compile>
104+
<Compile Include="..\C#-SQLite\src\Hash_h.cs">
105+
<Link>C#-SQLite\Hash_h.cs</Link>
106+
</Compile>
107+
<Compile Include="..\C#-SQLite\src\hwtime_c.cs">
108+
<Link>C#-SQLite\hwtime_c.cs</Link>
109+
</Compile>
110+
<Compile Include="..\C#-SQLite\src\insert_c.cs">
111+
<Link>C#-SQLite\insert_c.cs</Link>
112+
</Compile>
113+
<Compile Include="..\C#-SQLite\src\journal_c.cs">
114+
<Link>C#-SQLite\journal_c.cs</Link>
115+
</Compile>
116+
<Compile Include="..\C#-SQLite\src\keywordhash_h.cs">
117+
<Link>C#-SQLite\keywordhash_h.cs</Link>
118+
</Compile>
119+
<Compile Include="..\C#-SQLite\src\legacy_c.cs">
120+
<Link>C#-SQLite\legacy_c.cs</Link>
121+
</Compile>
122+
<Compile Include="..\C#-SQLite\src\loadext_c.cs">
123+
<Link>C#-SQLite\loadext_c.cs</Link>
124+
</Compile>
125+
<Compile Include="..\C#-SQLite\src\main_c.cs">
126+
<Link>C#-SQLite\main_c.cs</Link>
127+
</Compile>
128+
<Compile Include="..\C#-SQLite\src\malloc_c.cs">
129+
<Link>C#-SQLite\malloc_c.cs</Link>
130+
</Compile>
131+
<Compile Include="..\C#-SQLite\src\mem0_c.cs">
132+
<Link>C#-SQLite\mem0_c.cs</Link>
133+
</Compile>
134+
<Compile Include="..\C#-SQLite\src\mem1_c.cs">
135+
<Link>C#-SQLite\mem1_c.cs</Link>
136+
</Compile>
137+
<Compile Include="..\C#-SQLite\src\memjournal_c.cs">
138+
<Link>C#-SQLite\memjournal_c.cs</Link>
139+
</Compile>
140+
<Compile Include="..\C#-SQLite\src\mutex_c.cs">
141+
<Link>C#-SQLite\mutex_c.cs</Link>
142+
</Compile>
143+
<Compile Include="..\C#-SQLite\src\mutex_h.cs">
144+
<Link>C#-SQLite\mutex_h.cs</Link>
145+
</Compile>
146+
<Compile Include="..\C#-SQLite\src\mutex_noop_c.cs">
147+
<Link>C#-SQLite\mutex_noop_c.cs</Link>
148+
</Compile>
149+
<Compile Include="..\C#-SQLite\src\mutex_w32.cs">
150+
<Link>C#-SQLite\mutex_w32.cs</Link>
151+
</Compile>
152+
<Compile Include="..\C#-SQLite\src\notify_c.cs">
153+
<Link>C#-SQLite\notify_c.cs</Link>
154+
</Compile>
155+
<Compile Include="..\C#-SQLite\src\opcodes_c.cs">
156+
<Link>C#-SQLite\opcodes_c.cs</Link>
157+
</Compile>
158+
<Compile Include="..\C#-SQLite\src\opcodes_h.cs">
159+
<Link>C#-SQLite\opcodes_h.cs</Link>
160+
</Compile>
161+
<Compile Include="..\C#-SQLite\src\os_c.cs">
162+
<Link>C#-SQLite\os_c.cs</Link>
163+
</Compile>
164+
<Compile Include="..\C#-SQLite\src\os_common_h.cs">
165+
<Link>C#-SQLite\os_common_h.cs</Link>
166+
</Compile>
167+
<Compile Include="..\C#-SQLite\src\os_h.cs">
168+
<Link>C#-SQLite\os_h.cs</Link>
169+
</Compile>
170+
<Compile Include="..\C#-SQLite\src\os_win_c.cs">
171+
<Link>C#-SQLite\os_win_c.cs</Link>
172+
</Compile>
173+
<Compile Include="..\C#-SQLite\src\pager_c.cs">
174+
<Link>C#-SQLite\pager_c.cs</Link>
175+
</Compile>
176+
<Compile Include="..\C#-SQLite\src\pager_h.cs">
177+
<Link>C#-SQLite\pager_h.cs</Link>
178+
</Compile>
179+
<Compile Include="..\C#-SQLite\src\parse_c.cs">
180+
<Link>C#-SQLite\parse_c.cs</Link>
181+
</Compile>
182+
<Compile Include="..\C#-SQLite\src\parse_h.cs">
183+
<Link>C#-SQLite\parse_h.cs</Link>
184+
</Compile>
185+
<Compile Include="..\C#-SQLite\src\pcache1_c.cs">
186+
<Link>C#-SQLite\pcache1_c.cs</Link>
187+
</Compile>
188+
<Compile Include="..\C#-SQLite\src\pcache_c.cs">
189+
<Link>C#-SQLite\pcache_c.cs</Link>
190+
</Compile>
191+
<Compile Include="..\C#-SQLite\src\pcache_h.cs">
192+
<Link>C#-SQLite\pcache_h.cs</Link>
193+
</Compile>
194+
<Compile Include="..\C#-SQLite\src\pragma_c.cs">
195+
<Link>C#-SQLite\pragma_c.cs</Link>
196+
</Compile>
197+
<Compile Include="..\C#-SQLite\src\prepare_c.cs">
198+
<Link>C#-SQLite\prepare_c.cs</Link>
199+
</Compile>
200+
<Compile Include="..\C#-SQLite\src\printf_c.cs">
201+
<Link>C#-SQLite\printf_c.cs</Link>
202+
</Compile>
203+
<Compile Include="..\C#-SQLite\src\random_c.cs">
204+
<Link>C#-SQLite\random_c.cs</Link>
205+
</Compile>
206+
<Compile Include="..\C#-SQLite\src\resolve_c.cs">
207+
<Link>C#-SQLite\resolve_c.cs</Link>
208+
</Compile>
209+
<Compile Include="..\C#-SQLite\src\rowset_c.cs">
210+
<Link>C#-SQLite\rowset_c.cs</Link>
211+
</Compile>
212+
<Compile Include="..\C#-SQLite\src\select_c.cs">
213+
<Link>C#-SQLite\select_c.cs</Link>
214+
</Compile>
215+
<Compile Include="..\C#-SQLite\src\sqlite3ext_h.cs">
216+
<Link>C#-SQLite\sqlite3ext_h.cs</Link>
217+
</Compile>
218+
<Compile Include="..\C#-SQLite\src\sqlite3_h.cs">
219+
<Link>C#-SQLite\sqlite3_h.cs</Link>
220+
</Compile>
221+
<Compile Include="..\C#-SQLite\src\sqliteicu_h.cs">
222+
<Link>C#-SQLite\sqliteicu_h.cs</Link>
223+
</Compile>
224+
<Compile Include="..\C#-SQLite\src\sqliteInt_h.cs">
225+
<Link>C#-SQLite\sqliteInt_h.cs</Link>
226+
</Compile>
227+
<Compile Include="..\C#-SQLite\src\sqliteLimit_h.cs">
228+
<Link>C#-SQLite\sqliteLimit_h.cs</Link>
229+
</Compile>
230+
<Compile Include="..\C#-SQLite\src\status_c.cs">
231+
<Link>C#-SQLite\status_c.cs</Link>
232+
</Compile>
233+
<Compile Include="..\C#-SQLite\src\table_c.cs">
234+
<Link>C#-SQLite\table_c.cs</Link>
235+
</Compile>
236+
<Compile Include="..\C#-SQLite\src\tclsqlite_c.cs">
237+
<Link>C#-SQLite\tclsqlite_c.cs</Link>
238+
</Compile>
239+
<Compile Include="..\C#-SQLite\src\test1_c.cs">
240+
<Link>C#-SQLite\test1_c.cs</Link>
241+
</Compile>
242+
<Compile Include="..\C#-SQLite\src\test2_c.cs">
243+
<Link>C#-SQLite\test2_c.cs</Link>
244+
</Compile>
245+
<Compile Include="..\C#-SQLite\src\test3_c.cs">
246+
<Link>C#-SQLite\test3_c.cs</Link>
247+
</Compile>
248+
<Compile Include="..\C#-SQLite\src\test6_c.cs">
249+
<Link>C#-SQLite\test6_c.cs</Link>
250+
</Compile>
251+
<Compile Include="..\C#-SQLite\src\test9_c.cs">
252+
<Link>C#-SQLite\test9_c.cs</Link>
253+
</Compile>
254+
<Compile Include="..\C#-SQLite\src\test_autoext_c.cs">
255+
<Link>C#-SQLite\test_autoext_c.cs</Link>
256+
</Compile>
257+
<Compile Include="..\C#-SQLite\src\test_backup_c.cs">
258+
<Link>C#-SQLite\test_backup_c.cs</Link>
259+
</Compile>
260+
<Compile Include="..\C#-SQLite\src\test_config_c.cs">
261+
<Link>C#-SQLite\test_config_c.cs</Link>
262+
</Compile>
263+
<Compile Include="..\C#-SQLite\src\test_func_c.cs">
264+
<Link>C#-SQLite\test_func_c.cs</Link>
265+
</Compile>
266+
<Compile Include="..\C#-SQLite\src\test_hexio_c.cs">
267+
<Link>C#-SQLite\test_hexio_c.cs</Link>
268+
</Compile>
269+
<Compile Include="..\C#-SQLite\src\test_journal_c.cs">
270+
<Link>C#-SQLite\test_journal_c.cs</Link>
271+
</Compile>
272+
<Compile Include="..\C#-SQLite\src\test_malloc_c.cs">
273+
<Link>C#-SQLite\test_malloc_c.cs</Link>
274+
</Compile>
275+
<Compile Include="..\C#-SQLite\src\test_md5_c.cs">
276+
<Link>C#-SQLite\test_md5_c.cs</Link>
277+
</Compile>
278+
<Compile Include="..\C#-SQLite\src\test_mutex_c.cs">
279+
<Link>C#-SQLite\test_mutex_c.cs</Link>
280+
</Compile>
281+
<Compile Include="..\C#-SQLite\src\test_onefile_c.cs">
282+
<Link>C#-SQLite\test_onefile_c.cs</Link>
283+
</Compile>
284+
<Compile Include="..\C#-SQLite\src\tokenize_c.cs">
285+
<Link>C#-SQLite\tokenize_c.cs</Link>
286+
</Compile>
287+
<Compile Include="..\C#-SQLite\src\trigger_c.cs">
288+
<Link>C#-SQLite\trigger_c.cs</Link>
289+
</Compile>
290+
<Compile Include="..\C#-SQLite\src\update_c.cs">
291+
<Link>C#-SQLite\update_c.cs</Link>
292+
</Compile>
293+
<Compile Include="..\C#-SQLite\src\utf_c.cs">
294+
<Link>C#-SQLite\utf_c.cs</Link>
295+
</Compile>
296+
<Compile Include="..\C#-SQLite\src\util_c.cs">
297+
<Link>C#-SQLite\util_c.cs</Link>
298+
</Compile>
299+
<Compile Include="..\C#-SQLite\src\vacuum_c.cs">
300+
<Link>C#-SQLite\vacuum_c.cs</Link>
301+
</Compile>
302+
<Compile Include="..\C#-SQLite\src\vdbeapi_c.cs">
303+
<Link>C#-SQLite\vdbeapi_c.cs</Link>
304+
</Compile>
305+
<Compile Include="..\C#-SQLite\src\vdbeaux_c.cs">
306+
<Link>C#-SQLite\vdbeaux_c.cs</Link>
307+
</Compile>
308+
<Compile Include="..\C#-SQLite\src\vdbeblob_c.cs">
309+
<Link>C#-SQLite\vdbeblob_c.cs</Link>
310+
</Compile>
311+
<Compile Include="..\C#-SQLite\src\VdbeInt_h.cs">
312+
<Link>C#-SQLite\VdbeInt_h.cs</Link>
313+
</Compile>
314+
<Compile Include="..\C#-SQLite\src\vdbemem_c.cs">
315+
<Link>C#-SQLite\vdbemem_c.cs</Link>
316+
</Compile>
317+
<Compile Include="..\C#-SQLite\src\vdbe_c.cs">
318+
<Link>C#-SQLite\vdbe_c.cs</Link>
319+
</Compile>
320+
<Compile Include="..\C#-SQLite\src\Vdbe_h.cs">
321+
<Link>C#-SQLite\Vdbe_h.cs</Link>
322+
</Compile>
323+
<Compile Include="..\C#-SQLite\src\vtab_c.cs">
324+
<Link>C#-SQLite\vtab_c.cs</Link>
325+
</Compile>
326+
<Compile Include="..\C#-SQLite\src\walker_c.cs">
327+
<Link>C#-SQLite\walker_c.cs</Link>
328+
</Compile>
329+
<Compile Include="..\C#-SQLite\src\where_c.cs">
330+
<Link>C#-SQLite\where_c.cs</Link>
331+
</Compile>
332+
<Compile Include="..\C#-SQLite\src\_Custom.cs">
333+
<Link>C#-SQLite\_Custom.cs</Link>
334+
</Compile>
335+
<Compile Include="Classes\SQLiteDatabase.cs" />
336+
<Compile Include="Classes\SQLiteVdbe.cs" />
337+
<Compile Include="src\Benchmark.cs" />
338+
<Compile Include="Properties\AssemblyInfo.cs" />
339+
</ItemGroup>
340+
<Import Project="$(MSBuildBinPath)\Microsoft.CSharp.targets" />
341+
<!-- To modify your build process, add your task inside one of the targets below and uncomment it.
342+
Other similar extension points exist, see Microsoft.Common.targets.
343+
<Target Name="BeforeBuild">
344+
</Target>
345+
<Target Name="AfterBuild">
346+
</Target>
347+
-->
348+
</Project>

‎Benchmark/Benchmark.sln‎

Lines changed: 20 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,20 @@
1+
2+
Microsoft Visual Studio Solution File, Format Version 9.00
3+
# Visual Studio 2005
4+
Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "Benchmark", "Benchmark.csproj", "{F1653F20-D47D-4F29-8C55-3C835542AF5F}"
5+
EndProject
6+
Global
7+
GlobalSection(SolutionConfigurationPlatforms) = preSolution
8+
Debug|Any CPU = Debug|Any CPU
9+
Release|Any CPU = Release|Any CPU
10+
EndGlobalSection
11+
GlobalSection(ProjectConfigurationPlatforms) = postSolution
12+
{F1653F20-D47D-4F29-8C55-3C835542AF5F}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
13+
{F1653F20-D47D-4F29-8C55-3C835542AF5F}.Debug|Any CPU.Build.0 = Debug|Any CPU
14+
{F1653F20-D47D-4F29-8C55-3C835542AF5F}.Release|Any CPU.ActiveCfg = Release|Any CPU
15+
{F1653F20-D47D-4F29-8C55-3C835542AF5F}.Release|Any CPU.Build.0 = Release|Any CPU
16+
EndGlobalSection
17+
GlobalSection(SolutionProperties) = preSolution
18+
HideSolutionNode = FALSE
19+
EndGlobalSection
20+
EndGlobal

0 commit comments

Comments
 (0)