Re: VFP9SP1 How to determine # of rows using LLFF operations

Author: Stephen Russell

Posted: 2011-08-09 at 15:02:44

On Tue, Aug 9, 2011 at 1:40 PM, MB Software Solutions, LLC

<mbsoftwaresolutions@mbsoftwaresolutions.com> wrote:

> How do I determine the # of rows in a fixed-width flat file?  I want to

> provide a progress update in the loop so I know how much % of the file

> has been processed.  I'm trying to avoid reading the entire file in with

> ALINES.  (But I guess maybe I could do that but it seems like too much

> overhead.)

You are possibly blowing the wad on the string that you are generating?

Loop of reading lines

Str = str + "contents of this new line"

end

Even though it is the same name you are duplicating in memory what you

had to make the appended string.

I don't know when your pointers get released in VFP strings but as a

WAG this is where your memory hole is.

Have played with 1.2 and 1.5 gig xml files in ram before with no real

problem on workstations that only had 3 gig of ram. Teh process that

did monthly reporting I expanded to annual. ;-> made a bit bigger

output didn't it.

--

Stephen Russell

Unified Health Services

60 Germantown Court

Suite 220

Cordova, TN 38018

Telephone: 888.510.2667

901.246-0159 cell

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://leafe.com/mailman/listinfo/profox

OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message: http://leafe.com/archives/byMID/profox/CAJidMYLj2XFu=bVDzF=A=uJM3LPpHNJb-fRAraZyxfbpc4yB=A@mail.gmail.com

** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

©2011 Stephen Russell