Re: [SQL] Loading lots of data in a SQL command

2006-01-04 Thread Richard Huxton
frank church wrote: I am load lots of data via SQL into a database and wrapping it into transactions speeds it up. However this fails a number of times. The queries results are logged so it is easy for me to find problem records. However a single failure causes the whole transaction to fail. >

[SQL] Loading lots of data in a SQL command

2006-01-03 Thread frank church
I am load lots of data via SQL into a database and wrapping it into transactions speeds it up. However this fails a number of times. The queries results are logged so it is easy for me to find problem records. However a single failure causes the whole transaction to fail. Is there a setting or