Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Requery a SQL pass-through query
Message
From
09/04/2002 04:22:12
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00642228
Message ID:
00642511
Views:
15
Benoit,

It is my understanding that remote view queries can be precompiled to give small benefits (usually in milliseconds) in performance by negating the need to preapare the optimum query plan on re-execution.

In practice this will only give practical benefits if you going to requery hundreds of times.

The delay you are experiencing is either due to poor performance of the query on the server or the large volume of data you are downloading in your remote view.

If you haven't already done so I would concentrate your energies on adding indexes or otherwise improving the performance of the Query on the server.

Next, I would consider, if at all possible, narrowing the scope of the remote view by creating a paramterised view to reduce the overhead of data travelling over the network.

Best of luck

Steve
Previous
Reply
Map
View

Click here to load this message in the networking platform