Carlos, Wrapping the process in a single transaction reduced the time to only 4mins.
Thanks, Eduardo ""Carlos Guzmán Álvarez"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hello: > >> The problem with this approach is that FbDataAdapter.Update() is too >> slow. >> It takes almost 1 hour to copy aprox 500.000 rows. >> >> Is there a faster way to do this? or am I missing something? > > Can you try to wrap the inserts inside a single ( or several ones ) > transaction ?? > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2005. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > Firebird-net-provider mailing list > Firebird-net-provider@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
