Speeding up database access

Table Indexes Give tables Indexes if they will help with SELECT queries, e.g. Group Transactions SQLite is capable of carrying out many thousands of actions on a database per second, but not very many individually triggered transactions. You can work round this by grouping transactions such as INSERT or UPDATE to get a massive speed […]

Read More

Using a newer SQLite version

You’ll need to update the .Net Version your project is uses or you’lll get a compile error such as: ‘SQLite’: is not a member of ‘System::Data’ See here

Read More

Adding SQLite to a project

Get the latest set of files from system.data.sqlite.org. Binary packages are intended to be used for development and deployment of their applications onto customer machines.  Ensure you select the correct version for the .NET Framework version and Windows 32/64bit version your applicaiton targets.  Select the version without 'mixed-mode assembly' bundle. (Setup packages are intended for developer machines if […]

Read More

.SQLite General

´╗┐https://www.sqlite.org SQLite doesn't require any installation on the client machine.  It depends on the Visual C++ runtime, but you don't need to install it on the client machine. The system.data.sqlite download page contains several "static" packages that already contain the runtime. SQLite isn't a full SQL database, it uses a small set of datatypes and doesn't have […]

Read More