Re: Using Native VFP Tables and Network Performance
- From: "tom knauf" <hbgmail@xxxxxxxxxx>
- Date: Mon, 7 Apr 2008 12:47:28 +0200
Hi,
our network guy is reading this and laughing.
Your numbers are not so not much (compared to some of our apps :-).
A server here handles a VFP8 prog. with 80 Users , each 40-50 files opened
(and wordfiles, and ftp,,and email, and....)
I would suggest the following check :
Ask the users to stop all other software for the test.
Login and let one user after the other start work and see whether
performance of the fox app. becomes significantly (!) worse and worse.
Try to log, whats hapening ion the net (trafic, collisions,..), it could be
a "damaged" network controller card resulting in collision issues.
Other trafic issues resulting in small performance :
Printing big files (like powerpoint, could be 150 MB for 10 pages)
Massive internet use (surfing, mails with big attachements, live streams)
there are tools to measure network traffic snd show them in nice graphs
(e.g.:netman)
If only the fox network performance is an issue
Antivirus is always woth to be shut down on foxpro data.
I remember an old advice to make the exe read only and to have the DBC (if
not only free tables) locally generated on a local drive,
HTH
Tom
"Jeff Grippe" <jeff@xxxxxxxxx> schrieb im Newsbeitrag
news:7rCdnQFHU8jMpGjanZ2dnUVZ_h2pnZ2d@xxxxxxxxxxxxxxxx
Hello and thanks in advance for the help.
We are using VFP 7.0 SP1 and native VFP tables. All users are running Win
XP Pro SP2 and our file server is running Win 2003 Server.
We are running a network with about 30 users. Each user has 3 or 4 VFP
apps open with each app opening up to 40 tables. Most tables have memo
fields so each table opens 3 files. There are some forms with private data
sessions that open their own copies of from 25-30 tables (with memo
fields). Some of these forms are opened and closed repeatedly throughout
the day.
Are there any performance issues with using VFP tables and Win 2003 server
as I have outlined above? We are attempting to figure out why we are
having network performance issues and it has been suggested that the large
number of open files caused by the configuration that I have outlined
could be impacting network performance severely. Does anyone know if this
could be the case or if there are special configuration issues for Win
2003 Server that should be applied when using a large number of native VFP
tables.
Thank you very much.
Regards,
Jeff
.
- Follow-Ups:
- References:
- Using Native VFP Tables and Network Performance
- From: Jeff Grippe
- Using Native VFP Tables and Network Performance
- Prev by Date: Re: Any way to launch an external program from VFP within a specific size window?
- Next by Date: Re: Using Native VFP Tables and Network Performance
- Previous by thread: Re: Using Native VFP Tables and Network Performance
- Next by thread: Re: Using Native VFP Tables and Network Performance
- Index(es):
Relevant Pages
|
