Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
'USE remote_view NODATA' takes TOO MUCH time
A have several remote views fetching the data from MSSQL 7, all of them performing 4 to 6 left outer joins and having 5 to 8 AND'ed parameters.
The problem: one of those views takes TOO MUCH time to open with NODATA option (3-4 minutes), others are ok (I have the same delay when creating view definition, i.e. 'create sql view ... as...' causes 3 minutes delay).
I moved the definitions to the server (created server views w/out parameters) and reduces VFP definitions to 'select * from /server_view_name/ where /parameter_list/' - that didn't help.
Q1: Could somebody point me to an explanation of how VFP internally parses pre-defined views so I could localize the problem ?
Q2: Is it possible at all to work with large view definitions on VFP/MSSQL platform without using pass-through/MSSQL stored procedures?
P.S. Actually, when I redefine views both on VFP and MSSQL, the VFP view opens instantly for the first 3-4 times, then comes the delay... Anything to do with MSSQL view parameters?
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