On Tuesday 03 February 2009 12:01:47 pm Ed Leafe wrote: > On Feb 3, 2009, at 1:55 PM, johnf wrote: > > Just an update. I changed the way I was dealing with the data (use > > direct > > inserts) and the 217,000+ records took 48 mins. Maybe if I had > > waited longer > > it might have worked - but I can't confirm. > > When you say "direct inserts", do you mean running 217K+ > cursor.execute() statements? Did you try executemany()? > > -- Ed Leafe
Actually, I tried several ways. But I discovered that I had a few data issues in the data. By using execute statements it allowed me to see which pieces were giving trouble. And since this is more or less a one time deal - I just let it run. Thanks all. -- John Fabiani _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/[email protected]
