Edwin.Madari@Ve rizonWireless.c om wrote:
isn't that the point? -- he's building an argument array, and passing it
to executemany after it's reached a given size.
(to the OP, a quick code review doesn't reveal anything obvious -- but
you might want to test this with a much smaller dataset to make it
easier to debug. what happens if you call execute once for each row?
what happens if you call executemany after, say, 10 rows? what does
listofrec look like in that case if you print it?)
</F>
another thing - cumulative inserts will result, since
listofrec is not emptied after each sql execution.
listofrec is not emptied after each sql execution.
to executemany after it's reached a given size.
(to the OP, a quick code review doesn't reveal anything obvious -- but
you might want to test this with a much smaller dataset to make it
easier to debug. what happens if you call execute once for each row?
what happens if you call executemany after, say, 10 rows? what does
listofrec look like in that case if you print it?)
</F>