500% Performance Increase over ODBC

[Karbon]

That's not a typo - 500% - my db benchmark test is now consistently at *least* 5 times as fast as going through ODBC to an SQLite database.

[UserOfPure]

With regard to what? Due to v4.20 Final or something else? You didn't say.

[Karbon]

Sorry, yes, that is the native 4.2 SQLite support verses using the SQLite ODBC driver and the PB ODBC subsystem.

[srod]

I thought that the SQLite ODBC driver was buggy?

I'm not surprised to hear that the PB implementation is that much faster since it doesn't have to wade through the extra layer that is ODBC etc.

[Karbon]

It works pretty well on Win32 systems but doesn't support 64 bit Windows at all. I'm not surprised ODBC is slower than using the DLL directly either but I was surprised at how much slower.

Unfortunately I've still got to keep the SQLite driver as a dependency since ReportMan uses it to access data.