>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
Précédent
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