Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Need Info on VFP5 C/S
Message
De
19/11/1998 13:40:38
Raymond Humphrys
Michigan Department of Community Health
Bath, Michigan, États-Unis
 
 
À
19/11/1998 13:11:02
Diptesh Patel
Unitelsoftware Ltd.
Mumbai, Inde
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00159382
Message ID:
00159408
Vues:
19
>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 ...
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform