-----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" <[email protected]> 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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
