Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
n-Tier question
Message
De
14/11/2002 08:50:21
 
 
À
14/11/2002 05:29:58
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
Divers
Thread ID:
00722581
Message ID:
00722631
Vues:
13
>Hi
>
>What is SQL-Server's procedural language like? Is it any good to use as a middle-tier?
>
>This will be for a complex system where the rules are pretty heavy.
>
>Thanks
>Kev

Fast and short answer: in this case - no. SQL Server procedural language is actually Transact SQL. If you have many calculations and non linear and/or relational rules to follow, better is to use full-featured data manipulation language like this one in VFP.
On the other side, you may choose to code some of the logic as stored procedures, triggers, etc. in the SQL server database, but keep in mind that this has serve CPU overhead. If you use client processing with VFP you will have network traffic overhead, so that you should consider this trade-off.

HTH
Zlatin Zlatev,
MCSD (VS6)

Make solutions, not programs!

Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform