Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
n-Tier question
Message
From
14/11/2002 09:18:56
 
 
To
14/11/2002 08:50:21
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Miscellaneous
Thread ID:
00722581
Message ID:
00722647
Views:
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.

Thanks for the response.

Presumably if you have a powerful enough server, then the CPU overhead may be un-noticable?

Kev
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform