Subject | Re: [firebird-support] Re: Help: Firebird w/.NET provider performing 56% worse than Sql Server Compact Edition 3.5 SP2 .NET provider |
---|---|
Author | Helen Borrie |
Post date | 2011-02-16T08:34:17Z |
At 07:57 PM 16/02/2011, Matthew Adams wrote:
^ heLen ^
>I've narrowed some things down at this point.This isn't the .NET provider support list, which I note you have now subscribed to. Others, if you can help him, please follow it up on firebird-net-provider@...
>
>What I've noticed is that my Firebird select queries actually execute
>faster than the same queries in Sql Server Compact Edition, but when I
>start iterating the IDataReader (returned by cmd.ExecuteReader()),
>SSCE outperforms FB by a substantial margin.
>
>My suspicion is that FB is not fetching all records from the database
>at the initial query time. Can anyone confirm that? If I'm correct,
>how do I force FB to retrieve all data at the time of query using the
>.NET provider?
^ heLen ^