Re: corruption with vfp 8 - continued
- From: "swdev2" <wsanders@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Sat, 29 Apr 2006 22:38:38 -0600
Heya Jay.
VFP uses and consumes memory and (mostly) releases it back to the memory
pool .
I'm not stating explicitly that you have a memory problem - just that it's
an area to consider
on most levels, to restrict it.
VFP will try to use as much memory as possible, when possible, but if you
limit the amount of memory that it uses,
it will force writes and updates to occur more often, swapping things in and
out from memory to disk .
There are things to you can set in the .cfg file , and there are things you
can set in the app startup prgs itself to limit the memory.
I seem to recall some metric about it too.
For multiuser files, be sure you have your workstation vfp temp space to be
on the local disk of each workstation, as well.
You can also change the size of the ethernet packets on the workstation,
I've noticed some significant performance gains - but it seems each site is
different, because network topologies are different as well.
Also - on the workstations where things are working well, take note of the
drivers and the date/time filestamps and versions, and make sure these same
versions are installed on the workstations with the problems. Usually this
means the odbc drivers for ms-sql, but you can also look at any things you
use with the ms common controls (from the internet explorer installation
sets, of all things) and make sure you are using the same versions for
treeview, imagelist, etc.
Also review this stuff:
http://fox.wikis.com/wc.dll?Wiki~BigSystemPerformanceAndVisualFoxPro~VFP
http://fox.wikis.com/wc.dll?Wiki~NovellVFPIssues~VFP
http://fox.wikis.com/wc.dll?Wiki~CodeTuningTechniques~VFP
http://fox.wikis.com/wc.dll?Wiki~BigSystemDevelopmentWithVisualFoxPro~VFP
http://fox.wikis.com/wc.dll?Wiki~Client/ServerDataAccessTechniques~VFP
and this is the greatest list of stuff to review:
http://fox.wikis.com/wc.dll?Wiki~TuneFox~VFP
hth - regards [Bill]
--
===================
William Sanders / EFG VFP / mySql / MS-SQL
www.efgroup.net/vfpwebhosting
www.terrafox.net www.viasqlserver.net
"Jay B" <jayB@xxxxxxxxxxx> wrote in message news:Dkw4g.25$fM.22@xxxxxxxxxxx
Hi Bill,
i'm not using anything special to limit memory, why do you ask?
i remember reading something about that on old win98 with a lot of ram,
but not in xp. please tell me more.
each computer is fairly modern, 3.2ghz max, 4 of them are 550mhz all
with win2k or xp. each with 256mb min up to 1gb.
the problem has ocurred on:
sony vaio 3.0 xp 512,
clone, 500 xp 256
poweredge 512 win2k
sony 3.0 xp 512
dim2400 2.0 256 xp
optiplex gx280 3.2 1gb xp
those were the only computers out of 14.
and the problem seems to always occur during multiuser access.
i thought it could be networking, we have two switches piggy backed, one
in each room, but it happened between 2 computers on the same switch as
the server, unless that switch is going bad. but i'm not seeing any
problems whatsoever on any other apps, but i dont think the other apps
are sharing like foxpro is.
nothing makes sense as to why.
the other thing i'm thinking it could be is the different techniques i'm
using in code, for example, each form is a separate data session, tables
are opened usually using sql so the data is copied,
when i write back, i add/modify/delete thru one module with a separate
data session using SQL commands, and a few other import modules change
the data using APPEND FROM commands. some others quickly use a REPLACE
comand, but these are rare. so i'm not sure if mixing SQL with APPEND
creates an issue. the area which went south last nite was a payroll
update, where the user prepares the data, and adds the account
breakdowns, and after clicking save, i then lock the tables, then get
the next available transaction number, and do a quick 'append from' and
update the tran numbers and release the locks. i'm expecting tran
numbers and record row keys to be unique, and in this case, my query to
get the max didnt report records that another user just added so records
got overwritten. i'm working on rewriting some of this logic, add more
checking, etc. but i've been using this for other apps for some time and
it works pretty solidly.
swdev2 wrote:
Hullo Jay -
What are you doing to LIMIT the amount of memory your compiled VFP app
consumes?
regards [Bill]
.
- References:
- corruption with vfp 8 - continued
- From: Jay B
- Re: corruption with vfp 8 - continued
- From: swdev2
- Re: corruption with vfp 8 - continued
- From: Jay B
- corruption with vfp 8 - continued
- Prev by Date: Re: DBF to Excel File, 16383 is the limit ?
- Next by Date: Re: DBF to Excel File, 16383 is the limit ?
- Previous by thread: Re: corruption with vfp 8 - continued
- Next by thread: RE: Using Japanese language in a VFP 8 application
- Index(es):
Relevant Pages
|
Loading
