Information générale
Titre:
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement