Subject | Re: [firebird-support] Re: Help: Firebird w/.NET provider performing 56% worse than Sql Server Compact Edition 3.5 SP2 .NET provider |
---|---|
Author | Matthew Adams |
Post date | 2011-02-16T09:00:37Z |
Thanks. I just posted over there, then saw your response, Helen. If anyone
could pop over and have a look, I'd really appreciate it. I'm under the gun
on this one.
Sincerely,
Matthew
could pop over and have a look, I'd really appreciate it. I'm under the gun
on this one.
Sincerely,
Matthew
On Wed, Feb 16, 2011 at 2:34 AM, Helen Borrie <helebor@...> wrote:
>
>
> At 07:57 PM 16/02/2011, Matthew Adams wrote:
> >I've narrowed some things down at this point.
> >
> >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?
>
> 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@...
>
> ^ heLen ^
>
>
>
--
mailto:matthew@...
skype:matthewadams12
yahoo:matthewadams
aol:matthewadams12
google-talk:matthewadams12@...
msn:matthew@...
http://matthewadams.me
http://www.linkedin.com/in/matthewadams
[Non-text portions of this message have been removed]