>I am converting an application from vfp local table to sql server. I am not that knowledgeable about sql server performance tuning issues etc.
>
>On my pentium 4, 1.7 ghz w/ 512 megs of ram here is a comparison of the same update statement:
>
>my table sostrs has the same columns (about 95%) in both vfp and sql
>sostrs has 86000 rows
>
>vfp - ccustno has an index
>update sostrs set nreserved = 0 where CCUSTNO='ACME'
>550 rows updated in less than 1/10 of a second
>
>sql - index on primary key cuid
>update sostrs set nreserved = 0 where CCUSTNO='ACME'
>550 rows updated in 30 seconds (query performed in query analyzer)
>
>select * from sostrs where ccustno='ACME'
>
>takes 1/20 of a second in vfp and 0.00 in query analyzer
>
>
>Obviously vfp is orders of magnitude faster here. How do I tune my sql database for updating?
David;
What happens if your index for SQL Server is on CCustno? How about using a stored procedure?
Tom
Previous
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