For large data inserts liek that, look into doing a bulk copy. SQL Server is transactional and trying to blast 1,000,000 records into a table one by one (which is essentially what happens when NOT in bulk copy) is dfinitely going to be slow. It's just not what SQL is meant for. A bulk copy with that many records will still be slower than the VFP equivalent, but should take a lot less than 7 minutes.
With users adding, editing, and querying records in a more normal fashion, the difference will not be as great. The more users you add, eventually SQL Server will bypass VFP.
Randy
>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
Précédent
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