Re: [Firebird-net-provider] Cancel in FB embedded slow?

2013-07-03 Thread HERNAN MARTINEZ FOFFANI
> On Wed, Jul 3, 2013 at 12:36 PM, HERNAN MARTINEZ FOFFANI > wrote: >> I have a wrapper class that abstracts some layers and on some database >> engines (I don't remember which one, it might be SQLServer) if you call >> Close() on a command whose reader weren

Re: [Firebird-net-provider] Cancel in FB embedded slow?

2013-07-03 Thread HERNAN MARTINEZ FOFFANI
>> What I didn't expect was that all command.Cancel()'s to take (as reported by >> the profiler) more than 50% of the time. Such command is an ExecuteQuery >> and the DataReader had already read all the records. > > And why are you calling the Cancel? > I have a wrapper class that abstracts some

Re: [Firebird-net-provider] Cancel in FB embedded slow?

2013-07-03 Thread HERNAN MARTINEZ FOFFANI
>> Profiling my application I found that one bottleneck seems to be when >> canceling a cursor. It also happens even if it was already consumed (i.e., > > What bottleneck? > I was profiling my application to look up where to apply our optimization efforts. The process I was measuring is a big

[Firebird-net-provider] Cancel in FB embedded slow?

2013-07-02 Thread HERNAN MARTINEZ FOFFANI
Hi, Profiling my application I found that one bottleneck seems to be when canceling a cursor. It also happens even if it was already consumed (i.e., finished to read all the rows). Is this an expected behavior? I'm asking because it may very well be a bug in our data layers. I might also avoid

Re: [Firebird-net-provider] Exception on exit application

2013-04-25 Thread HERNAN MARTINEZ FOFFANI
> > I have a wpf application, and when exiting I always get a debug output: > > A first chance exception of type 'System.NullReferenceException' occurred in > FirebirdSql.Data.FirebirdClient.dll > > Firebird 2.5, Firebird Client 3.0.2.0, Runtime v4.0.30319 > > I havn’t been able to track d

Re: [Firebird-net-provider] ClearAllPools and opened connections

2013-04-25 Thread HERNAN MARTINEZ FOFFANI
>> You could also see it from a different point: some part of your code is >> misbehaving (ie not releasing connections back to the pool in a timely > > Interesting. I would say why your code isn't going to be fixed in > first place? And should the library offer tools for this in first > place? >

Re: [Firebird-net-provider] config best practice

2012-12-19 Thread HERNAN MARTINEZ FOFFANI
El 19/12/2012, a las 08:18, Jiri Cincura escribió: > You can use . That's exactly what I was looking for: a remove (it doesn't fail if not present) before an add. Should have realized it myself. Thanks a lot. -- LogM

[Firebird-net-provider] config best practice

2012-12-18 Thread HERNAN MARTINEZ FOFFANI
Hi, What is the best practice for the app.config file? Right now, I'm including a section in the app.config bundled in our installer. But what if some of our users have already installed Firebird.NET in their machine and have in their machine.config a FB entry? Won't my application fail when l