Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread problem in Bulk Insert
Wed, Apr 29 2009 5:28 AMPermanent Link

mkalone@gmail.com
hi,
i need to insert 200000 records at once in a Table.
i use Standalone Version.

my records saved in table but need 1  to 3 minutes time.

can i pass multi insert commands at once to table?


language is C#.
Wed, Apr 29 2009 6:04 AMPermanent Link

"Eduardo [HPro]"
> i need to insert 200000 records at once in a Table.
> i use Standalone Version.
>
> my records saved in table but need 1  to 3 minutes time.
>
> can i pass multi insert commands at once to table?
Are you using transaction ? If not try using transaction commiting for every
5000 records (for example). Another way, if it is possible, is opening the
target table exclusively.

Eduardo

Image