Re: [sqlite] OLE DB provider for SQLite
> 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. :) ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] OLE DB provider for SQLite
-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]> Content-Type: text/plain; charset=ISO-8859-1 >> 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 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] OLE DB provider for SQLite
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: [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 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++) ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] OLE DB provider for SQLite
> 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++) ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] OLE DB provider for SQLite
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. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] OLE/DB provider for SQLite?
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 it isn't easy programming and it doesn't make sense for most of the major languages exactly for the difficulty in making it work right. It's easy to just use the native language wrappers for this, but that will not work in other languages (or even different frameworks, like VCL/MFC). If you think my "business plan" is not fair, I would be pleased to ear any alternatives you might have to make it better. An alternative businessplan you can consider, could be like Marco Wobben has with the DBXpress-driver. You can give it for free, but ask money for the source-code. When it works good, I guess you can sell some of your source-codes. You could also have restrictions on the binary only version, for example, not to use for commercial projects. Maybe I would be the source-code, just for not being dependant to someone else for a critical driver in my software projects. I am glad I bought the source code from Marco Wobben, because he does not want to do some small changes I need. Regards Bert Verhees Best regards, ~Nuno Lucas
Re: [sqlite] OLE/DB provider for SQLite?
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 provider exactly to help a friend. I don't have any need for that. There are many payed wrappers for sqlite (including COM ones). Just visit the links in the wiki and you'll see that. I don't want to displease anyone, and it is the first time I intend to make some money from an "open source" project, but I also think we should get rewarded from doing things we don't like to do (that is called working as opposed to just programming for fun). For most people, a simple OLEDB provider would do the trick - there are plenty of examples of writing these in any MS language you like (VB, C etc) 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. The reason for this, IMHO, is because it isn't easy programming and it doesn't make sense for most of the major languages exactly for the difficulty in making it work right. It's easy to just use the native language wrappers for this, but that will not work in other languages (or even different frameworks, like VCL/MFC). If you think my "business plan" is not fair, I would be pleased to ear any alternatives you might have to make it better. Best regards, ~Nuno Lucas
Re: [sqlite] OLE/DB provider for SQLite?
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
Re: [sqlite] OLE/DB provider for SQLite?
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 classes (a DLL containing the OLE/DB COM interface). He say he already can use the ODBC driver, but that the ODBC handling classes (native to the language model) are old, slow and full of bugs (and deprecated to the VOAdo interface). I know there are ADO or ADO-like interfaces, but they seem to not implement the OLE/DB layer. From my understanding this may be what makes having so many language wrappers, as if an OLE/DB implementation was available it would work with almost all languages that have an OLE/DB or ADO wrapper (like VCL for Delphi/C++ Builder, etc). If no OLE/DB wrapper exists, where can I get information on how to implement one? (to see if it's easy or not) Any help would be appreciated, thanks. ~Nuno Lucas 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
[sqlite] OLE/DB provider for SQLite?
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 containing the OLE/DB COM interface). He say he already can use the ODBC driver, but that the ODBC handling classes (native to the language model) are old, slow and full of bugs (and deprecated to the VOAdo interface). I know there are ADO or ADO-like interfaces, but they seem to not implement the OLE/DB layer. From my understanding this may be what makes having so many language wrappers, as if an OLE/DB implementation was available it would work with almost all languages that have an OLE/DB or ADO wrapper (like VCL for Delphi/C++ Builder, etc). If no OLE/DB wrapper exists, where can I get information on how to implement one? (to see if it's easy or not) Any help would be appreciated, thanks. ~Nuno Lucas
