Mark,
I don't use SQL Server, but rather another SQL database. When I run a query in my interactive window it returns the first 5 records and then I need to press "more" to get another group. Does your enterprise manager return all rows in 5 seconds or just the first few? The time for VFP would be the time to return all rows.
I also know that returning data across the wire is pretty slow, but of course you are running all on the same machine, so this is not the problem you are having.
>Hi guys. I am having around 50,000 records in my sql server table. I have a filtered query which takes around 5 seonds if i run it from sql server enterprise manager.
>
>but if i try to run same query through vfp , it takes around 16 seconds. I don't have any memo fields in sql server data. also I am fetching all the records at once through view. i don't understand why this much of difference in speed?
>
>btw, i am running the query off vFp from the same machine where sql server is.
>
>anyone have idea? thanks in adavnce.
>mark
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