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 execution
- 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?
thanks
------------------------------------------------------------------------------
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
