Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Any Experience with SQL Server 2000 speed ?
Message
From
23/07/2003 05:09:28
 
 
To
22/07/2003 08:30:30
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00812241
Message ID:
00812686
Views:
11
Hi Petros,

SQL Server is faster on Data Set manipulation,
but is slower on row Data Processing 2 to 10 times vs VFP.

Exists 3 way:
- use Data Set command, like UPDATE, and SQL UDF
(attention, not use Scalar UDF with SELECT command )
- read data on VFP or C++, Processing and send result to SQL
- uses SQL Extended Stored Procedures.

Fabio
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform