Ionut Filip wrote:
I thought I read somewhere that the DLL is actually built with gcc and linked against the VC++ 6 runtime. Better results might be seen building with the actual Microsoft compiler. While I haven't had any speed issues my apps don't stress the database heavily. The Microsoft compiler tends to generate fairly fast code. The Intel compiler has a reputation for faster code and might be worth a shot, but the Borland compiler doesn't have a reputation for fast code at all, and I've had a few ugly run-ins with it in the past. There are some people here who use it though, so maybe they'll be good enough to give it a whirl for us.Hi,
So the VC++ 7.1 dll is much faster than the VC++ 6, up to 20% in some operations, and the "MS mixed dll load bug" is not a problem, assuming sqlite doesn't mix native code with managed .net code :).
Anyone using other compiler to build sqlite on Windows ? Maybe Borland ? I seems there is a lot o room for faster sqlite.dll by using other compiers than VC++ 6. We can run some tests to see which is faster ...
Clay Dowling