Have you tried rows to disk option on the dw?
-----Original Message-----
From: Mullings, Daniel [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 23, 1999 10:43 AM
To: [EMAIL PROTECTED]
Cc: PbHelp List (E-mail); PB-L List (E-mail); PFCSIG
List (E-mail)
Subject: PFCSIG Out of Memory Error on large import
Hey Phil,
Any resolution to the problems below?
I am experiencing the same problem!!
Phil Fausz wrote:
<snip>
We're running into problems using datawindows and getting
memory errors when
the result set is greater than 100,000 rows. We've run
several tests, here
are two:
1) PC - p300, 256MB RAM, 1 GB virtual memory. Get error at
108,800.
2) PC - p400, 64MB RAM, 500 MB Virtual Memory. Error at
108,820.
We did the same test with PB 5, 6, 6.5, and 6.5.1. We ran
out of memory at
(approximate values):
pb5 - 500,000 rows.
pb6 - 250,000 rows.
pb6.5 - 150,000 rows.
pb6.5.1- 108,000 rows.
<snip>
<snip>
With PB.6.0 and higher, datawindows crash with 'Out of
Memory' errors after
retrieving (or importing) as few as 145,000 rows. The amount
of virtual
memory used at this point is fairly consistent with the
levels for PB.5.0.02
after the same # of rows, with plenty of virtual memory
still available!
<no attachment>
The attached ZIP file contains a PBL with a single
'external' datawindow
object and a compatible tab-delimited dataset which can be
imported into the
datawindow. I limited the dataset size to 50,000 rows, but
it's easy enough
to produce the errors by importing the file multiple times.
Under releases
PB.6.5 and PB.6.5.1, expect to get an 'Out of Memory' error
during the 3rd
import (between 100,000 and 150,000 rows) !
I had a little more luck with PB6.0, but eventually it died
(around 430,000
rows) with plenty of Virtual Memory still available!
<snip>
|---------------------------------------------------|
Daniel Mullings
MTSC - Systems Engineer
GTE Data Services
Irving, Texas
[EMAIL PROTECTED]
|---------------------------------------------------|
> [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST
SERVE COMMANDS, ADDRESS
> A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING
MESSAGE: help pfcsig
> SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
> [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS, ADDRESS
> A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help pfcsig
> SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
