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
Previous
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