FoxPro Help and Support

Author

record count

pxriet

2005-07-07, 11:25 am

Is there a limit to how many records I can process within a program. I have
maybe 15 - 20 million records that I am running through a program to format &
do some calculations before rolling up?

Craig Berntson

2005-07-07, 11:25 am

You're limited only by memory and the maximum table size.

--
Craig Berntson
MCSD, Visual FoxPro MVP
www.craigberntson.com
Salt Lake City Fox User Group
www.slcfox.org
www.foxcentral.net

"pxriet" <pxriet@discussions.microsoft.com> wrote in message
news:C5E35E05-C814-4432-8798- 26B6F8E0A4CD@microso
ft.com...
> Is there a limit to how many records I can process within a program. I
> have
> maybe 15 - 20 million records that I am running through a program to
> format &
> do some calculations before rolling up?
>
>

pxriet

2005-07-07, 8:30 pm

I am on an IBM thinkpad laptop. 1.6 ghz & 512 mb of RAM. I have broken the
modules down into 2 million line chunks, but it runs extremely slow. Do you
think I need a memory upgrade, and if so, how much?

"Craig Berntson" wrote:

> You're limited only by memory and the maximum table size.
>
> --
> Craig Berntson
> MCSD, Visual FoxPro MVP
> www.craigberntson.com
> Salt Lake City Fox User Group
> www.slcfox.org
> www.foxcentral.net
>
>
> "pxriet" <pxriet@discussions.microsoft.com> wrote in message
> news:C5E35E05-C814-4432-8798- 26B6F8E0A4CD@microso
ft.com...
>
>
>

Lee Mitchell

2005-07-07, 8:30 pm

Hi Pxriet:

First, you have to determine what commands are causing the slow
performance. Use the Coverage Profiler for this task.

http://support.microsoft.com/defaul...KB;EN-US;191953

If the performance problems revolve around accessing data, then look at the
SYS(3050) and SYS(3054) functions. See
http://support.microsoft.com/defaul...KB;EN-US;176483
http://support.microsoft.com/defaul...KB;EN-US;156551
http://support.microsoft.com/defaul...KB;EN-US;248608

I hope this helps.

This posting is provided "AS IS" with no warranties, and confers no rights.

Sincerely,
Microsoft FoxPro Technical Support
Lee Mitchell

*-- VFP9 HAS ARRIVED!! --*
Read about all the new features of VFP9 here:
http://msdn.microsoft.com/vfoxpro/

*--Purchase VFP 9.0 here:
http://www.microsoft.com/PRODUCTS/i...cid=54787e64-52
69-4500-8bf2-3f06689f4ab3&type=ovr

Keep an eye on the product lifecycle for Visual FoxPro here:
http://support.microsoft.com/default.aspx?id=fh;[ln];lifeprodv
- VFP5 Mainstream Support retired June 30th, 2003
- VFP6 Mainstream Support retired Sept. 30th, 2003

>I am on an IBM thinkpad laptop. 1.6 ghz & 512 mb of RAM. I have broken
the
>modules down into 2 million line chunks, but it runs extremely slow. Do
you
>think I need a memory upgrade, and if so, how much?

>"Craig Berntson" wrote:
[color=darkred]
> You're limited only by memory and the maximum table size.
>
> --
> Craig Berntson
> MCSD, Visual FoxPro MVP
> www.craigberntson.com
> Salt Lake City Fox User Group
> www.slcfox.org
> www.foxcentral.net
>
>
> "pxriet" <pxriet@discussions.microsoft.com> wrote in message
> news:C5E35E05-C814-4432-8798- 26B6F8E0A4CD@microso
ft.com...

Craig Berntson

2005-07-08, 11:24 am

With today's operating systems that consume RAM, then you add software
firewalls, anti-virus, email, services, etc, etc, etc, RAM quickly gets
eaten up. I consider 512 to be the minumum needed. Additional RAM could help
things.

BTW, I just upgraded my ThinkPad to 2 Gig. It was only about $350US.

--
Craig Berntson
MCSD, Visual FoxPro MVP
www.craigberntson.com
Salt Lake City Fox User Group
www.slcfox.org
www.foxcentral.net

"pxriet" <pxriet@discussions.microsoft.com> wrote in message
news:3DC96B45-7613-4BE1-BF1E- 146DC29ADB8A@microso
ft.com...[color=darkred]
>I am on an IBM thinkpad laptop. 1.6 ghz & 512 mb of RAM. I have broken
>the
> modules down into 2 million line chunks, but it runs extremely slow. Do
> you
> think I need a memory upgrade, and if so, how much?
>
>
>
> "Craig Berntson" wrote:
>

Sponsored Links