Will do. I'll keep my workaround then of reopening the connection after the Execute and comment it for whomever gets the code (probably me).
It would be nice to have a LOAD statement (or utility) to batch load data from a CSV (or other delimited text) file. The third party utilities suggested by the Firebird website really don't fit the bill since they either don't work (do not handle NULLs, BLOBs, or are depricated. Or they only offer a GUI interface which I do not want to pass on to my users). Right now, I create an FbBatchExecution object (which is how I found this 'bug') and load from there. It has got my problem of loading 260,000 records down to about 15 minutes, but I think that can be improved. Is anyone working on this? If not, I may take a stab at it if I can find the time. Brian -----Original Message----- From: Jiri Cincura Sent: Thursday, April 04, 2013 11:09 PM To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] Question on FbBatchExecution On Fri, Apr 5, 2013 at 3:07 AM, Brian Liedtke <lied...@frii.com> wrote: > Any reason for this? Because it's implemented like this. :) It's probably bug. It should close the connection only if it opened it. Create a tracker item for this. I'll fix it into next release. ------------------------------------------------------------------------------ Minimize network downtime and maximize team effectiveness. Reduce network management and security costs.Learn how to hire the most talented Cisco Certified professionals. Visit the Employer Resources Portal http://www.cisco.com/web/learning/employer_resources/index.html _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
