Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
That was it. Congradulations. 5 *****
Thanks James.
>Make sure ODBC trace is not turned on.
>
>>>>It returns the results in less than a second.
>>>
>>>It doesn't. Management studio displays the result as soon as the first few dozens records are available. If you look closely, you see that the query is still executing, even though Management studio already displays a result. VFP waits for the query to be complete (or for a larger number of records) before it returns. If you execute the query asynchronously in VFP, you should get a result much quicker, too. VFP would keep loading in the background.
>>
>>It seems that it something wrong with my machine.
>>I run the same queries in an other machine (more or less of the same capabilities) same database data etc
>>and returns the results in light speed. The connection is established in a flush while in the one with the problem it takes about a second.
>>Also something very strange:
>> a) query1 select top 100 f1, f2, f3, .f4 from mydatabase.dbo.mytablerec it takes about 20 seconds
>> b) query2 select top 100 f1, f2 from mydatabase.dbo.mytablerec it takes about 10 seconds
>> c) query3 select top 100 f1 from mydatabase.dbo.mytablerec it takes about 5 seconds
>>
>>Is there a virus problem ? I am afraid that I have to format it and install everything again.
>>But on the other hand other VFP programs work fine!.
Précédent
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