Re: Python, MS SQL, and batch inserts

In message , Dennis Lee Bieber wrote: > On Thu, 23 Apr 2009 21:00:48 +1200, Lawrence D'Oliveiro > declaimed the following in > gmane.comp.python.general: >> >> Nothing wrong with that >> . > > Eeeek! That whole page seems to take

Re: Python, MS SQL, and batch inserts

In message , Philip Semanchuk wrote: > Are you sure your logjam is in Python? Inserting 5500 rows can take a > few seconds if you're COMMITting after each INSERT. Wrap the whole > thing in an explicit transaction and see if that helps. Does MS-SQL have the equivalent of "insert delayed"

Re: Python, MS SQL, and batch inserts

In message , Dennis Lee Bieber wrote: > You don't mean to say you are creating full SQL insert statements > WITH THE DATA! Nothing wrong with that . -- http://mail.python.org/mailman/listinfo/python-list

Re: Python, MS SQL, and batch inserts

On Apr 21, 5:21 pm, Scott David Daniels wrote: > ericwoodwo...@gmail.com wrote: > > On Apr 21, 4:01 pm, ericwoodwo...@gmail.com wrote: > >> On Apr 21, 3:36 pm, Scott David Daniels wrote: > >>> I forget the name of the SQL Server bulk loader, > > bcp (bulk copy) was the name of the bulk

Re: Python, MS SQL, and batch inserts

ericwoodwo...@gmail.com wrote: On Apr 21, 4:01 pm, ericwoodwo...@gmail.com wrote: On Apr 21, 3:36 pm, Scott David Daniels wrote: I forget the name of the SQL Server bulk loader, bcp (bulk copy) was the name of the bulk loader. I just remembered. Sorry, no more exciting advice. i

Re: Python, MS SQL, and batch inserts

On Apr 21, 4:01 pm, ericwoodwo...@gmail.com wrote: > On Apr 21, 3:36 pm, Scott David Daniels wrote: > > > Philip Semanchuk wrote: > > > ... If you're doing a mass insert to populate a blank table it also often > > > helps to postpone index creation until after the table is populated > > > I fo

Re: Python, MS SQL, and batch inserts

On Apr 21, 3:36 pm, Scott David Daniels wrote: > Philip Semanchuk wrote: > > ... If you're doing a mass insert to populate a blank table it also often > > helps to postpone index creation until after the table is populated > > I forget the name of the SQL Server bulk loader, but for large load

Re: Python, MS SQL, and batch inserts

Philip Semanchuk wrote: ... If you're doing a mass insert to populate a blank table it also often helps to postpone index creation until after the table is populated I forget the name of the SQL Server bulk loader, but for large loads, I used to populate a fresh table with the bulk data, th

Re: Python, MS SQL, and batch inserts

On Apr 21, 2009, at 2:30 PM, ericwoodwo...@gmail.com wrote: I'm not 100% sure it's python and not SQL but I do suspect there's a better way to do this than just serial inserts. I could be wrong about that which is what i'm trying to explore. I don't think the SQL standard provides a way to

Re: Python, MS SQL, and batch inserts

On Apr 21, 2:15 pm, Philip Semanchuk wrote: > On Apr 21, 2009, at 2:02 PM, ericwoodwo...@gmail.com wrote: > > > > > Hi, > >     I have a python script I'm writing that grabs some data from a > > com object, does a little formatting, and then inserts that data into > > a MS SQL 2003 DB.  Because I'

Re: Python, MS SQL, and batch inserts

On Apr 21, 2009, at 2:02 PM, ericwoodwo...@gmail.com wrote: Hi, I have a python script I'm writing that grabs some data from a com object, does a little formatting, and then inserts that data into a MS SQL 2003 DB. Because I'm using COM objects I'm importing win32com.client. That also all

Python, MS SQL, and batch inserts

Hi, I have a python script I'm writing that grabs some data from a com object, does a little formatting, and then inserts that data into a MS SQL 2003 DB. Because I'm using COM objects I'm importing win32com.client. That also allows me to use ADODB.connection and ADODB.command objects for wo