System.Data.SQLite

Login
This project makes use of Eagle, provided by Mistachkin Systems.
Eagle: Secure Software Automation
Ticket Hash: e66749bb5b51f180f7f29abe0c0d09298a587aa2
Title: Monster DLL vs Interop vs Native
Status: Closed Type: Performance
Severity: Cosmetic Priority: Immediate
Subsystem: Native_Assembly Resolution: Not_A_Bug
Last Modified: 2011-11-13 18:45:32
Version Found In: 1.0.76.0
Description:
- Is there any performance difference between the Monster DLL (mixed mode assembly) or using the seperate Sqlite.Interop.dll? 

- What is the difference between using the Sqlite.Interop.dll VS the native/official sqlite3.dll?

<hr /><i>mistachkin added on 2011-11-13 18:45:32 UTC:</i><br />
1. The "monster" DLL might be a bit faster; however, this has not been measured.

- What is the difference between using the Sqlite.Interop.dll VS the native/official sqlite3.dll?

2. The SQLite.Interop.dll includes some special native code that allows it to better integrate with the System.Data.SQLite managed code.  It is possible to use System.Data.SQLite with the official sqlite3.dll if you compile it with the UseSqliteStandard MSBuild property enabled and the UseInteropDll MSBuild property disabled (see the file SQLite.NET.Settings.targets in the root of the source tree).