Hi,

I beleive, below message is quite old. But I'm new subscriber and met this 
one while searching something.

I have very similar problem too. Could you get any solution? 
Did you tried to select the records only you need instead of all. It is 
increasing the performance. Please let me know if anyone has better 
solution.
Thanks.


Futuh COKLU
futuh@t...


> Hi friends,
> 
> I'm facing difficulties in browsing VFP tables on ASP.
> 
> The size of the table(hlpg) has 300M,
> and I build index on archivesnm in vfp.
> 
> I use the following code on asp:
> 
> set xConn = Server.CreateObject("ADODB.Connection")
> xConn.connectionstring="Provider=VFPOLEDB.VFPOLEDB;Data 
> Source=d:\vfptest\tastrade.dbc"
> xConn.open 
> 
> set xrs = Server.CreateObject("ADODB.Recordset")
> strsql="SELECT * FROM hlpg where archivesnm < '0101000'"
> xrs.Open strsql, xConn
> 
> If not use index on asp ,it is very slow. 
> How can I use vfp index on asp ? 
> Can anyone show me the sample coding ?
> Please help me!