Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Network:
Windows 2003 Server
>>I use remote views to manage SQL Server data in my application. I discover something special when I investigate how remote views are interpreted in SQL Server :
>>
>>Sometimes the view is created as an "SELECT ..." preceded by "SET FMTONLY ON" and followed by "SET FMTONLY OFF", sometimes the view is created as an "sqlprepare" followed by the SELECT statement.
>>Could you explain that difference ?
>>
>>Moreover when I use "USE ... NODATA" to open a remote view, VFP have to generate (see VFP help) a where clause like "WHERE 1=2", it works well in most of my customers except one (In France). Could you explain that difference ?
>>
>
>Marc,
>
>What exactly is the problem with customer tn France?
Sergey,
When I trace SQL instructions with SQL profiler on the customer's server, I observe that the "USE ... NODATA" is not converted in SQL as an SELECT statement with "WHERE 1=2" as where clause. The SELECT have no where clause so I think that when view is created SQL extract all data to return view structure.
Actually my application is very slow on this site especially when the user open a form managed with remote views. When I repeat the same transactions with the same data on my server, I don't have the same performances, it's much faster.
I'll hope you have some good ideas for me.
Marc
Précédent
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