Most of my queries are quick, less than a second per record but one form is
very slow >5 min per record. It contains two grids and I suspect that refreshing them have something to do with the bad perfomance, but I have not had time to look into it.

> When you say 'reasonably well', what sort of performance are you getting? The reason I ask is that my app also uses the Client Access ODBC driver to retrieve data from my client's AS400 system, and some queries are incredibly slow. But it is inconsistent, sort of as if more data then I ask for is being retrieved and then cached. For example, the user will key in an ID code, if the record with that ID code is not found in the local VFP table, a query is issued against the DB2 data on the AS400. I am returning 2 columns only, and the WHERE condition is the aformentioned ID code, which the people who maintain the DB2 data assure me is indexed. The record set is rather large, but there should be one and only one hit. This takes as long as 5 minutes at times. After being presented with the contents of the two fields retrieved, to verify that this is indeed the record the user was looking for, if they continue on I do a second query which retrieves the entire row with the WHERE clause
>specifying the ID code, in other words, the first query is SELECT name1,name2 FROM as400connection WHERE ID = myIDCode, and the second query is SELECT * FROM as400connection WHERE ID = myIDCode. The the results of the second query are then inserted into the local VFP table and the user is presented with an edit window. The WHOLE second part, AS400 query, VFP Insert, and form load, takes less than a second. Any thoughts?
>
>Thanks,
> Randy
>
>>
>>I use the DB2 Database on the AS400,IBM Client Acess OBCD driver,VFP7, Remote Views and SQL PassThrough to work with data on the AS400 and it works resonably well.
>>
>>Omar