I can confirm this. FWIW we just recently, along with other developers, found out that first converting the source to CSV and then linking it as EXTERNAL TABLE into the database, is in total _MUCH_ faster than using any type of client managed import logic.
~~~Ihre Nachricht~~~ JC> 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? JC> There's no transaction log in Firebird. Consider also committing per JC> i.e. 10000 records. And also using execute block, to batch commands. JC> Anyway I would recommend you, to do this on server, via i.e. external JC> tables. --- ------------------------------------------------------------------------------ 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
