Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Differences between xBase and SQL implementations
Message
 
To
20/12/1999 23:36:06
Victor Chigne
Inteliventas
Peru
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00305631
Message ID:
00306765
Views:
38
>>Way to complicated and more of a pain to manage. Also, in many cases, going to VFP data is not an option. Tell you what, go to an IT guy who has made an investment in SQL Server, and tell him that to get the best performance, you need to use VFP. If I were the IT guy, I would pick you up, and throw you through a window..
>>
>>Most VFP folks insist on taking a VFP-data mindset to SQL Server. Instead of telling the guy to use a VFP crutch, you should tell him how to use SQL Server properly....
>>
>
>Well, AFAIK replicating data locally for speed is an accepted way to optimize CS systems.....

Sometimes we force VFP on our clients. John is bringing to fact that they want to use SQL.

I disagree with replicating data between VFP & SQL. That's not optimizing, it's only a crutch. I have found that the people who are SQL only are serious about their decission. They have invested alot of capital in equipment, software and licenses. I would try to do what the client wants his way, and allow VFP to manipulate the data my way.

Moreoften the biggest issue for VFP is security, in that there is none. SQL you have some very substancial security. Don't tell me about Encrypting data because that's not security, it's duct tape.

__Stephen
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform