Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remote Views, SQL PT, or ADO?
Message
From
22/11/1999 18:46:02
 
 
To
21/11/1999 22:13:10
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00293784
Message ID:
00294129
Views:
26
>Use SPT if......
>
>You are dealing with large data sets, are comfortable with T-SQL, and/or have identity or uniqueidentifier fields defined in the SQL Server database.


John, let me give you a hypothetical architecture:

VFP Client or Browser front-end
VFP Middleware
SQL Backend

In this situation all of the updates and most of the traffic to the SQL Db would come from the VFP middleware. It would probably make sense to allow for a reporting package like Crystal that would access the SQL DB directly.

The middleware would have few or no forms so data-binding is not really an issue. I think we could also imagine that other n-tier components would talk to the middleware and not the SQL DB.

In this case using SPT looks likes a no-brainer.

Do you agree?

Peter Robinson
Peter Robinson ** Rodes Design ** Virginia
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform