There are a couple of things you can try to speed up your application in a LAN environment, with a VFP database:

1. Make sure your queries are Rushmore optimized. See the SYS(3054) function

2. There was an article in FoxPro Advisor back in 1999 (I think) that detailed how VFP brings a lot of the index across the network. The article points out how to alleviate this, including removing the DELETED() index.

3. DCOM. A VFP DCOM server can sit on the same machine as the VFP data. When called be a client program (VFP in your case), the DCOM server is on the same machine as the VFP data, so processing is not slowed down by transferring the data across the network.

>I am trying to increase the performance our programs. At the present we do all processing on the client side. I have heard that it is better to do this on the server side. This I assume means STORED PROCEDURES. Question, are they faster for SQL statements. The following works:
>
>nconhandle = sqlexec(nhandle, mysqlstatement, 'mycursor')
>
>From here I can use the cursor I retrieved. What I would like, is to have the statement on the server in a stored procedure. If that is the way to go for this kind of data retrieval. What I don’t know is how to call that procedure and return the cursor.
>
>We are using VFP6 SP3 with a standard VFP database.
>
>Any & all thoughts are welcome.
>TIA
>Mike