General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi!
>Do you have indexes on the Product field and DELETED()?
Yes, on the Product field. What do you mean with indexing on DELETED - I never create such an index?
>Is this query being run across the network?
>If the VFP data is sitting on a file server and
>you are running the query from a workstation, what kind
>of results do you get if you run the query at the file server?
Actually, I don't have a particular configuration on my mind - of course there is a better performance if it runs on a server or on a single user machine, but it's still not acceptable, because users need this information lots of times during entering, searching, etc.
Zlatko.
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