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 loop

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 layers

[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] 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? If you

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 down a

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

2012-12-19 Thread HERNAN MARTINEZ FOFFANI
El 19/12/2012, a las 08:18, Jiri Cincura disk...@cincura.net escribió: You can use remove ... /. 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.

[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 system.dataDbProviderFactories 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?