OLE DB provider for SQLite

[Marcin Walkowiak (Work-Local Account)]

Is there any OLE DB provider for SQLite other than provider from Cherry
City Software:

http://cherrycitysoftware.com/ccs/Providers/ProvSQLite.aspx

Unfortunately this provider does not work well with one of my company's
project (it must with Analysis Services and OLAP).

Could You tell me, are there another OLE DB providers?


PS Managed (ADO.NET) providers do not satisfy requirements for
performance reasons.

[Brad Stiles]

Post by Marcin Walkowiak (Work-Local Account)
PS Managed (ADO.NET) providers do not satisfy requirements for
performance reasons.

That's a pretty blanket statement. I've found Robert Simpson's
ADO.NET provider to be very performant. He has a benchmarking suite
he wrote to compare various DBs. It might still be available for
download.

http://sqlite.phxsoftware.com/forums/t/174.aspx (Desktop)
http://sqlite.phxsoftware.com/forums/t/175.aspx (Mobile)
http://sqlite.phxsoftware.com/forums/p/17/33.aspx#33 (Comparing C# to C++)

[Robert Simpson]

Agreed. There may be some scenarios in which the C interface or some
C++/OLEDB interface to SQLite outperforms the ADO.NET provider significantly
-- but in most cases there is only a negligible performance impact that can
only be measured through thousands of iterations.

-----Original Message-----
From: sqlite-users-bounces-CzDROfG0BjIdnm+***@public.gmane.org
[mailto:sqlite-users-bounces-CzDROfG0BjIdnm+***@public.gmane.org] On Behalf Of Brad Stiles
Sent: Monday, November 17, 2008 6:54 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] OLE DB provider for SQLite

Post by Marcin Walkowiak (Work-Local Account)
PS Managed (ADO.NET) providers do not satisfy requirements for
performance reasons.

That's a pretty blanket statement. I've found Robert Simpson's
ADO.NET provider to be very performant. He has a benchmarking suite
he wrote to compare various DBs. It might still be available for
download.

http://sqlite.phxsoftware.com/forums/t/174.aspx (Desktop)
http://sqlite.phxsoftware.com/forums/t/175.aspx (Mobile)
http://sqlite.phxsoftware.com/forums/p/17/33.aspx#33 (Comparing C# to C++)

[Marcin Walkowiak]

-----Original Message-----
Date: Mon, 17 Nov 2008 08:53:44 -0500
From: "Brad Stiles" <bradley.stiles-***@public.gmane.org>
Subject: Re: [sqlite] OLE DB provider for SQLite
To: "General Discussion of SQLite Database" <sqlite-users-CzDROfG0BjIdnm+***@public.gmane.org>
Message-ID:
<9f4dcd640811170553n9357e72h8794320d1d1c00ea-JsoAwUIsXosN+***@public.gmane.org>
Content-Type: text/plain; charset=ISO-8859-1

Post by Brad Stiles

Post by Marcin Walkowiak (Work-Local Account)
PS Managed (ADO.NET) providers do not satisfy requirements for
performance reasons.

That's a pretty blanket statement. I've found Robert Simpson's
ADO.NET provider to be very performant. He has a benchmarking suite
he wrote to compare various DBs. It might still be available for
download.

The problem with performance is not caused directly by SQLite provider, but by different way of reading data from managed (ADO.NET) providers by Analysis Services.

I know managed SQLite providers (like System.Data.SQLite) well, and I know that they are fast. I've tested performance of them. But in this case the difference between OLE DB providers and ADO.NET providers is great. For example when we underline MSSQL provider for SSAS:

ADO.NET (System.Data.SQLClient): 114 sec
OLE DB (SQLNCLI.1): 23 sec

This performance problem IS NOT restricted to SQLite provider, it occurs in all ADO.NET providers I've tested.

KoD

[Brad Stiles]

Post by Marcin Walkowiak
The problem with performance is not caused directly by SQLite provider, but by different
way of reading data from managed (ADO.NET) providers by Analysis Services.

Ah. "Analysis Services". 'Nuff said. Missed that the first time around. :)