Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
CREATE VIEW Local+Remote
Here is a problem I am sure has been solved many times over.
I have a local table A with a few hundred records that I want to join to a remote table B holding several million records. Running VFP 5.0
Problem 1: When I CREATE the remote view (programatically) as SELECT * FROM B, it goes away and seems to actually populate the view. At least the odometer says so. Millions and millions and way too much time. How do I stop this from happening ?
Problem 2: When I try to build the Local+Remote view using the View
Designer, it blows up. Is this common ?
Problem 3: Is there a strategy or syntax that I can use to optimize the Local+Remote view so that it does not pass all of the Remote View over to the Client side ? I currently use SELECT remoteview.* from
localview,remoteview where localview.a=remoteview.a
Thanks for any help.
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