VFP appliaction very slow

Dear
I have a problems. When I put the Visual Foxpro database file to LAN
Server share to lan Workstation access. I load the record very slow. Can you
advice which solution can define this problems.

Thanks
Jackie Wong

Rick
Thu Oct 21 07:45:20 CDT 2004

Jackie,
Without a lot more information not much can be recomended.

What is the configuration of the server - OS, RAM, HDs, NICs, etc.? What =
is the configuration of the workstations - OS, RAM, HDs, NICs, etc.? =
What is the configuration of the network topology - speed, NICs, cables, =
hubs, switches, routers, etc.? Are you runing the VFP code file on the =
network server or locally on each machine? Are you putting the temp =
files locally or on the network server. What's in your CONFIG.FPW? What =
version and service pack level of VFP are you using? How did you install =
the application on the workstations? What in the application is "slow'? =
What do you consider slow? (Timings for specific - provided - code on =
both the local system and on the server would be useful. Please include =
table sizes, structures and indexs available.)=20

There are many more questions, but these are a good start.

Rick

"ITJACKIE" <it_jackie@hotmail.com> wrote in message =
news:uPMxfg2tEHA.2980@tk2msftngp13.phx.gbl...
> Dear
> I have a problems. When I put the Visual Foxpro database file to LAN
> Server share to lan Workstation access. I load the record very slow. =
Can you
> advice which solution can define this problems.
>=20
> Thanks
> Jackie Wong
>=20
>

Paul
Thu Oct 21 22:11:09 CDT 2004

Could be a number of things:

1. Slow or badly performing network. Fix the network.
2. Large data files - use smaller ones if possible. You could also move to
client-server, but that's a fair amount of work.
3. Maybe your application is requesting more data than it actually needs.
Try to do more with less.
4. If you're using queries, make sure you have indexes on the appropriate
fields.
5. If you're using a lot of data that doesn't change much, try creating a
local cache so you don't have to keep getting it from the network.



"ITJACKIE" <it_jackie@hotmail.com> wrote in message
news:uPMxfg2tEHA.2980@tk2msftngp13.phx.gbl...
> Dear
> I have a problems. When I put the Visual Foxpro database file to LAN
> Server share to lan Workstation access. I load the record very slow. Can
> you
> advice which solution can define this problems.
>
> Thanks
> Jackie Wong
>
>

KevClark64
Fri Oct 22 09:03:04 CDT 2004

If possible, I would suggest that you use the coverage profiler. The
profiler will report how many times each function/line runs and how
long each function/line takes. This can be a real eye-opener.

One thing that seems to be particularly slow, especially over a
network, is opening and closing files. If you can open files the
files you need at the beginning of your program and keep them open, it
may speed up your application.

Kevin Clark
Seton Home Study School