memory leaks doing unloads
Hi folks,
Env: 4.10 4GL and 4.10 SE on SCO Unix
I am writing a program to archive data from the customer's database into
one archive file. The user selects the customers to archive and I
write unload files and copy all the files into 1 large archive.
My problem is that the user was archiving 6000 master records (and lots of
detail records) and ran out of memory. The core dump was 15MB in size.
I think I have tracked down the offending statement. It is the unload.
I have an array of table names and do something like the following:
define i,j smallint
tabnames array[50] of char(18),
str char(200),
fname char(14)
let fname = "junk"
for i = 1 to j
let str = "select * from ",tabnames[i] clipped,
" where prospno = \\"",pr_prospect.prospno clipped,"\\"",
unload to fname str
end for
Other unloads must use joins in the select statement linking 2 tables
together to unload specific records from one table, but the method of
executing the unload statement is the same. Build a str variable and
unload to fname str
As the program runs, the core memory size gets larger and larger.....
By removing the unload commands and simulating the unloads, the rest of
the program hardly grows in core size at all.
Does anyone know how to dealloc the memory being sucked up by the unload
command? Or, any better ways to export selected bits of tables?
Dbexport doesn't allow specific records to be unloaded.
I could write reports, parsing out the syscolumn entries to build lines
that look like "unload" lines.
Thanks for reading this far. Any ideas?
------------------------------------------------------------------------------
Alan Goodman | Data Systems Support
Sr.Programmer/Analyst | 1228 Shelly Ct.
internet : alan@dssmktg.com | Orange, CA 92668 USA
bangpath: uunet.uu.net!dssmktg!alan | Voice 714-771-0454 Fax 714-771-3028
------------------------------------------------------------------------------