Re: Occurs Depending Memory Use

In article <_sydne3EEO579g_fRVn-hQ@xxxxxxxxxx>,
Kevin Solomon <kjsolo@xxxxxxxxxx> wrote:

[snip]

>The problem is simply that we have a program that for the next processing
>year will require seven or eight tables of between 1 and 10,000 occurrences
>and we're endevouring to find a way to use only the amount of memory that is
>actually necessary for each iteration.

Hmmmmm... sounds like a system that's outgrown its original specs and has
been patched and prodded and 'all ya gotta do is'd' until nothing more
along those lines will work.

[snip]

>The number of occurences that are required for each iteration is variable
>upon a count of transactions returned from a DB call. Does anyone have any
>ideas on how memory use might be optimized?

Sure... and I'll give it to you for free, too. It is a single word of
eight letters, it starts with 're', ends with 'design' and has been
defined as 'to revise in appearance, function or content'.

Need more than that? Not a problem, have someone who has budgetary
authority to sign my timesheets get in touch with me.

>
>Thanks.

No prob... worth at least double what I've asked you to pay for it.

DD
.