>>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only