Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Any Experience with SQL Server 2000 speed ?
Message
 
To
25/07/2003 02:23:29
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00812241
Message ID:
00813944
Views:
8
Do you have an example of the sort of formulae you are applying to the data?

I have seen figures in the past where people have had problems with comparing the performance of VFP and SQL Server, however a different approach is usually needed with SQL because it is set-based.

Would it be more sensible to do all of the processing in VFP then, and post the final result set to SQL in a batch at the end?

What are your drivers for using SQL Server in the first place?

Regards
Simon
SJC Systems Limited
WorldSpreads Limited (www.worldspreads.com)
Previous
Reply
Map
View

Click here to load this message in the networking platform