RE: DBI Connect Fails after 20,000 record inserts/updates

2002-10-24 Thread Dallas Engelken
Thursday, October 24, 2002 10:32 AM > To: [EMAIL PROTECTED] > Subject: RE: DBI Connect Fails after 20,000 record inserts/updates > > > Do you connect/disconnect before/after every insert? > > -Original Message- > From: Dallas Engelken [mailto:dallase@;nmgi.com] > Sent

RE: DBI Connect Fails after 20,000 record inserts/updates

2002-10-24 Thread Artem Koltsov
Do you connect/disconnect before/after every insert? -Original Message- From: Dallas Engelken [mailto:dallase@;nmgi.com] Sent: Thursday, October 24, 2002 9:52 AM To: [EMAIL PROTECTED] Subject: DBI Connect Fails after 20,000 record inserts/updates I am trying to parse an email log databas

Re: DBI Connect Fails after 20,000 record inserts/updates

2002-10-24 Thread gerald_clark
It looks like you are using a network connection. Perhaps you are running out of connections, as closed sessions may take a while to be freed. Try keeping the second connection open until you are done. Dallas Engelken wrote: I am trying to parse an email log database with about 900,000 records f