Page 1 of 1
500% Performance Increase over ODBC
Posted: Sun Jun 01, 2008 4:13 am
by 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.
Re: 500% Performance Increase over ODBC
Posted: Sun Jun 01, 2008 5:17 am
by UserOfPure
With regard to what? Due to v4.20 Final or something else? You didn't say.
Posted: Sun Jun 01, 2008 5:27 am
by Karbon
Sorry, yes, that is the native 4.2 SQLite support verses using the SQLite ODBC driver and the PB ODBC subsystem.
Posted: Sun Jun 01, 2008 10:39 am
by 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.
Posted: Sun Jun 01, 2008 3:07 pm
by 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.