>>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.
Thanks for the response.
Presumably if you have a powerful enough server, then the CPU overhead may be un-noticable?
Kev
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement