Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Some questions about SQL server 2000/ VFP 7.0
Message
From
02/10/2002 01:41:08
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Some questions about SQL server 2000/ VFP 7.0
Miscellaneous
Thread ID:
00706710
Message ID:
00706710
Views:
53
Hello all,

Questions
=========

1. How can I connect and call SQL server store procedure from VFP ?

2. I tried to insert records 1000000 in a #temp table in sql server and it was very slow (7 minutes). In VFP is 7 seconds !!. There is any way to make SQL server faster? (The server is 6 processors, 2GB ram, RAID5).

3. I continued my tests with SQL statements and VFP is still faster. The problem is that SQL server does not have the concept of VFP cursor ?

4. There is a document of explaining this behaviour (SQL Server / VFP) ?

Thanks in advance
Petros
Next
Reply
Map
View

Click here to load this message in the networking platform