Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Need Info on VFP5 C/S
Message
From
19/11/1998 13:40:38
Raymond Humphrys
Michigan Department of Community Health
Bath, Michigan, United States
 
 
To
19/11/1998 13:11:02
Diptesh Patel
Unitelsoftware Ltd.
Mumbai, India
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00159382
Message ID:
00159408
Views:
18
>Need more info on IMPLEMENTING C/S application using
>VFP 5.0
>Issues : Speed , Network trafic , robstness , backhand

I have implemented several C/S apps using VFP5 with SQL Server 6.5 and Oracle 7.3 & 8.0. I used a Compaq 7000 with 512mb ram, 91gb RAID, with a 100 mbit fiber channel between the server and the external storage device. The tables were over 1.5 million records and about 1 k length, with several tables linked together. Approx. 15,000 to 40,000 updates / month.

Using VFP as a front end was easy. I used a combination of Remote views, SQL passthrough, and server side store procedures. With all server tables indexed I had requirements that all records had to be able to be retrieved in less than 5 seconds. This on a NT 4.0 network with approx. 75 users. This was all done with very little problem.

I've done the same stuff using VB 4.0; not so easy. Lots of work coding.

ray
Some days it's not worth chewing through the leather straps ...
Previous
Reply
Map
View

Click here to load this message in the networking platform