Re: corruption with vfp 8 - continued

thanks thomas.
wow, i still cant believe that with all the memory and resources in these modern computers, this is still an issue here.


Thomas Ganss wrote:
Hi Jay,

there still are some memory issues in vfp8 and vfp9.
I encountered a few 1150's in a reproducable manner
in certain levels of sys(3050) settings.

The general rule seems to be to set sys(3050) to something below
192 MB even on very well equipped machines
(ranging from 512 MB to 2 GB,
Swap file size = Max(1.5GB, 1.5*PhysicalMem) )
Verified in vfp8Sp1, vfp9Sp0, vfp9Sp1.

The funny thing is that there seems to be no fail/works-limit:
for instance the 2 Gig machines would
work at 192
fail at 250MB,
work at 390MB,
fail at 500MB
work at default setting (nearly 700MB)

and I've not found a pattern across every mem setting.

Since the "my" problematic app has it's roots back in 2.x
it is mostly xBase code - seek, scan, locate - which is
often quicker when running in fairly limited memory space,
I was able to minimize sys(3050) in most of the program.

I'ld reccommend setting memory to someting like
min(PhysicalRAM*0.2, 112) MB via setup method.
If there are areas the app is working poorly because of starved mem,
(SQL Joins, reindexes and so on) bump up before and lower down afterwards.

And make sure that the area each user's tempfiles are
created in is large enough.

One other thing: I had 43's crop up on one machine where
one of the disks ran at high temperature (too many disks
and a hot running PIV). Not using that disk helped a lot <g>

my 0.02 EUR

thomas
.

Relevant Pages

  • Re: alpha box and licence too? - Suggestions
    ... > The TC systems are old and relatively slow, ... The DEC 3000 machines also have METAL CASINGS. ... > these systems shipped with 32-64 MB of memory. ... > compatible storageworks disks are all fine provided you obtain the right ...
    (comp.os.vms)
  • Re: Iomega Parallel Zip 100 drive (boxed/mint)
    ... I have one of these and 10 disks. ... Who would want to buy 1GB of capacity in a big box and spread over ten discs, when you can buy the same on a memory stick for a few pounds? ... OK, where there have been several machines in an office, these are now mostly redundant and backup is done on a network. ...
    (uk.adverts.computer)
  • Re: influencing the order in which page and swap files are used
    ... whereas if I buy more memory it is tied to that box. ... I plan on moving some conventional disks on the ... SCSI bus which would have the SSDs to other machines in the cluster. ...
    (comp.os.vms)
  • Re: corruption with vfp 8 - continued
    ... there still are some memory issues in vfp8 and vfp9. ... 192 MB even on very well equipped machines ... one of the disks ran at high temperature (too many disks ... and a hot running PIV). ...
    (microsoft.public.fox.helpwanted)
  • Re: VPF v3.0b on XP Prof.
    ... While I haven't tried this on an XP machine, I did on Win 9x, and it didn't seem to help VFP 3.0b - it may be using an API call to check the physical memory. ... "Thomas Ganss" ... acessible to the OS (for perf tests across a simulated spectrum of memory ...
    (comp.databases.xbase.fox)