RE: Need speed

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Lee Mitchell (Leemi_at_online.microsoft.com)
Date: 06/09/04 

Date: Wed, 09 Jun 2004 21:08:06 GMT

Hi:

The first thing I would look at is optimizing VFP's internal memory with
the SYS(3050) function. See the Help file topic for SYS(3050) and this
article for more information:

176483 PRB: Large Amounts of RAM Seem to Process Data Slowly
http://support.microsoft.com/?id=176483

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 Public Beta Now Available!! --*
Download the VFP9 beta here: http://msdn.microsoft.com/vfoxpro/

*-- VFP8 HAS ARRIVED!! --*
Read about all the new features of VFP8 here:
   http://www.universalthread.com/VisualFoxPro/News/VFP8Release.asp
Purchase VFP8 here:
   http://shop.microsoft.com/Referral/Productinfo.asp?siteID=11518
 
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'm importing a bunch of pay records into a table ('PAY TABLE') with
already contains over
>10,000 records. I create an updatable View of the Pay Table and set 'Table
Buffering' on.
>The View is parameterized to the current pay period only and is where I
import all the new
>records into as well as do the calculations for them. The more the records
added, the longer the >process is taking!
>Once the process is complete, I issue a TABLEUPDATE(.T.) (all rows)
command to the View
>thereby commiting all the new/modifed records to the pay table. At first,
I thought it was all my
>calculations that were slowly down the process. It turns out that it's
the saving part that is
>REALLY slow. Am I doing something wrong?

Relevant Pages

  • Re: Keeping and caculating historically correct data?
    ... > employee through a certain date.... ... results and delete the elements of the calculations. ... > corresponding rate for each day in the pay period. ...
    (comp.programming)
  • Re: Negotiated fee rate
    ... Are they hiding the relatively low rates from the uninsured? ... >>have to pay a bill without the evidence of the calculations used? ... > held close to the vest by the insurer. ...
    (talk.politics.medicine)
  • Re: simple formatting
    ... Once in the new number fields i will do the calculations ... a Number or Currency datatype field. ... data, then you will have unending problems with calculations, with data ... Your choice - pay now, ...
    (microsoft.public.access.formscoding)
  • Re: simple formatting
    ... Once in the new number fields i will do the calculations ... a Number or Currency datatype field. ... data, then you will have unending problems with calculations, with data entry, ... Your choice - pay now, ...
    (microsoft.public.access.formscoding)
  • Re: simple formatting
    ... Once in the new number fields i will do the calculations ... a Number or Currency datatype field. ... data, then you will have unending problems with calculations, with data entry, ... Your choice - pay now, ...
    (microsoft.public.access.formscoding)