General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
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