Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Will this query take long time using SPT?
Message
From
18/11/2000 05:56:33
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00443073
Message ID:
00443352
Views:
16
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.
>
Previous
Reply
Map
View

Click here to load this message in the networking platform