Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP vs. SQL Server
Message
From
10/12/1998 16:00:10
 
 
To
05/01/1996 17:45:14
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00000029
Message ID:
00166308
Views:
17
>>Hiya Bill ----

>>Yes. A VFP app with the native database engine *is* faster. But it seems to me that speed is not your only issue here.

I'm aware of that, but in this case I don't see it as much more than that.

>>Certainly there has to be *some* I/O with the data server? And that could come from a number of different apps, right? Sounds like the data management capabilities of SQL Server are needed.

95%+ of the data is read-only. The value for the customer is mostly the data.

>>This sounds like a topological nightmare regardless of whether or not VFP or SQL Server is managing the data.

Agreed.

Things not mentioned -- Data Maintenance (DBA stuff). This is a breeze with VFP, but a bear with SQL Server.
>
>>SQL Server 7.0 makes some giant strides in ease-of-use. In fact, I've had some SQL Server DBAs tell me that they fully expect that some applications may not even need to be babysitted by a fulltime DBA.

Yeah, that's been echoed by others on this thread. I've signed up for a MSFT course on SQL Server 7.0 this Saturday. Hopefully that will shed some light as well.
>
>John, part-time DBA (i.e. consultant) may be more expensive :).

Thanks for your input,

Bill
Integrity, integrity, integrity!
Previous
Reply
Map
View

Click here to load this message in the networking platform