> 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. :)
___
-Original Message-
Date: Mon, 17 Nov 2008 08:53:44 -0500
From: "Brad Stiles" <[EMAIL PROTECTED]>
Subject: Re: [sqlite] OLE DB provider for SQLite
To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org>
Message-ID:
<[EMAIL PROTECTED]
-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] 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
> PS Managed (ADO.NET) providers do not satisfy requirements for
> performance r
> 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.
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
Did you noticed there are very few open source OLE/DB providers? MySQL
only has one, and not maintained since 2001. It started as a commercial
project and only later (L)GPL'ed.
There is one open source for Inteerbase:
http://sourceforge.net/projects/iboledb/
The reason for this, IMHO, is because
Steve O'Hara, dando pulos de alegria, escreveu :
Nuno,
You're not going to be making too many friends here with that
attitude
To my knowledge, all the wrappers for SQLite are free and most authors will
also give you the source code too if you want it.
Well, I decided to make the OLE/DB
nfr, dando pulos de alegria, escreveu :
There is a nice OLE provider project from xml file at
http://www.viksoe.dk/code/xmloledb.htm
Maybe you can use that as a starting point.
Regards
Noël
Unfortunally it is only binary freeware (a DLL), no source code.
But thanks, anyway.
~Nuno Lucas
Nuno Lucas wrote:
Hi,
I'm really asking this in name of a friend of mine, which is
programming in VisualObjects and wanted to use his VoAdo classes with
SQLite.
I really don't understand much of the subject, but from what I
understood he needs an OLE/DB provider so he can use SQLite with this
Hi,
I'm really asking this in name of a friend of mine, which is programming
in VisualObjects and wanted to use his VoAdo classes with SQLite.
I really don't understand much of the subject, but from what I
understood he needs an OLE/DB provider so he can use SQLite with this
classes (a DLL
10 matches
Mail list logo