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
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
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
I am trying to parse an email log database with about 900,000 records for records
older than 2 days (ie 600,000 records).
I make a dbi connection and select all records older than 2 days. It returns the rows.
Now I step through each row with a while loop, and if the entry is a virus, i open a
