Edhy
Mon Feb 14 00:21:51 CST 2005
This is a multi-part message in MIME format.
------=_NextPart_000_0081_01C51233.8FC14FD0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi Rusty G.
a.. You can modify the application to use Local Views to try to speed =
up some forms. =20
b.. Make sure you have all the proper indexes required by your =
business rule.
c.. If possible, convert the application to use MySQL, MSDE or SQL =
Server Express 2005 (Beta 2) with Remote Views, this will definitely =
increase the application data processing by just transferring the data =
needed by the user in the current form, instead of loading the whole =
data into memory with VFP tables.=20
--=20
Edhy Rijo
www.progytech.com
Bronx NY
"Rusty G" <ogallo@columbus.rr.com> wrote in message =
news:x7VPd.39509$i42.16600@fe1.columbus.rr.com...
> I've developed an application use VP6. Users are using a VPN with =
cable=20
> and DSL. They say it runs a little slow. The application is loaded on =
the=20
> local machine and it looks to the server across the network for the =
data. Is=20
> there anything I should have done or could have done to make =
processing the=20
> information quicker.
> Note I developed the application use all free tables.
>=20
> Rusty G
>=20
>
------=_NextPart_000_0081_01C51233.8FC14FD0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2900.2523" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV><FONT face=3DArial size=3D2>Hi Rusty G.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<UL>
<LI><FONT face=3DArial size=3D2>You can modify the application to use =
Local Views=20
to try to speed up some forms. </FONT></LI>
<LI><FONT face=3DArial size=3D2>Make sure you have all the proper =
indexes required=20
by your business rule.</FONT></LI>
<LI><FONT face=3DArial size=3D2>If possible, convert the application =
to use MySQL,=20
MSDE or SQL Server Express 2005 (Beta 2) with Remote Views, this=20
will definitely increase the application data processing by=20
just transferring the data needed by the user in the current =
form,=20
instead of loading the whole data into memory with VFP=20
tables. </FONT></LI></UL>
<DIV><FONT face=3DArial size=3D2>-- <BR>Edhy Rijo<BR></FONT><A=20
href=3D"
http://www.progytech.com"><FONT face=3DArial=20
size=3D2>www.progytech.com</FONT></A><BR><FONT face=3DArial =
size=3D2>Bronx=20
NY</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>"Rusty G" <</FONT><A=20
href=3D"mailto:ogallo@columbus.rr.com"><FONT face=3DArial=20
size=3D2>ogallo@columbus.rr.com</FONT></A><FONT face=3DArial =
size=3D2>> wrote in=20
message </FONT><A =
href=3D"news:x7VPd.39509$i42.16600@fe1.columbus.rr.com"><FONT=20
face=3DArial =
size=3D2>news:x7VPd.39509$i42.16600@fe1.columbus.rr.com</FONT></A><FONT=20
face=3DArial size=3D2>...</FONT></DIV><FONT face=3DArial =
size=3D2>> =20
I've developed an application use VP6. Users are using a VPN with cable =
<BR>>=20
and DSL. They say it runs a little slow. The application is loaded on =
the=20
<BR>> local machine and it looks to the server across the network for =
the=20
data. Is <BR>> there anything I should have done or could have done =
to make=20
processing the <BR>> information quicker.<BR>> =
Note I=20
developed the application use all free tables.<BR>> <BR>> Rusty =
G<BR>>=20
<BR>></FONT></BODY></HTML>
------=_NextPart_000_0081_01C51233.8FC14FD0--