On Wed, Feb 17, 2010 at 10:44, korkless <[email protected]> wrote:
> - i do all the insertions in a single transaction (there's no concurrent
> access to db during this operation)
>
> i read that maybe disabling the transaction log can speed up the process,
> it's possible to do that with the net provider?
There's no transaction log in Firebird. Consider also committing per
i.e. 10000 records. And also using execute block, to batch commands.
Anyway I would recommend you, to do this on server, via i.e. external
tables.
--
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.cincura.net/ | http://www.ID3renamer.com
------------------------------------------------------------------------------
SOLARIS 10 is the OS for Data Centers - provides features such as DTrace,
Predictive Self Healing and Award Winning ZFS. Get Solaris 10 NOW
http://p.sf.net/sfu/solaris-dev2dev
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
