General information
Title:
Some questions about SQL server 2000/ VFP 7.0
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only