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,
On Wed, Feb 17, 2010 at 10:44, korkless 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
hi, i must do a massive data insertion (~10 milion rows) using ado.net/firebird
net provider on a single table.
what expedients can i do to speed it? (i'm not very good in databses so also
simple suggestions are good)
- there's a single index wich i will destroy/recreate before/after the execut
