Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to speed up data retrival from SQL Server
Message
From
30/07/2004 09:21:51
John Baird
Coatesville, Pennsylvania, United States
 
 
To
30/07/2004 09:02:58
Raoshan Kumar
Softinfo Systems Pvt. Ltd.
New Delhi, India
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: How to speed up data retrival from SQL Server
Miscellaneous
Thread ID:
00929547
Message ID:
00929552
Views:
16
Make sure you have indexes(clustered or otherwise) on your tables. This will speed up access.


>Hi All,
>
>I'm using SQL passthrough functions to get data from SQL server 2000, but the rate of data retrival is very slow; (on the server itself). Can you pl help me out how to get the data from the SQL Server quickly. I m using VFP 7; SQL Server 2000 and SQL Passthrough Functions
>
>Thanks
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform