Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Will this query take long time using SPT?
Message
De
18/11/2000 05:56:33
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00443073
Message ID:
00443352
Vues:
10
Hi Hector,

I am not using SQL server. It was Oracle in one company and VFP in another company. I have the client side programming same for both. But I got the picture now. Thanks for the response.

Regards

>I assume you are talking to SQL Server. If that is the case I don't think you will see performance decrease as the table grows.
>
>FWIW, here is another way of getting the structure of your table
>
>set fmtonly on
>select * from mytable
>set fmtonly off
>
>I don't know if this will increase/decrease performance. But if you open a view with NODATA this is what VFP send to SQL Server.
>
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform