>>you may want to re-design this to bring and update data in smaller chunks alltogether - of course I don't know enough on your program so what you are doing might be the most sensible way to go
>
>This would be ideal, but it's not possible. Some of the data in the dbf comes from the remote view and I need to search the remote view for it. Almost obvious, I cannot search it if I don't retrieve all the data first.

Just an idea but you may be able to do a SELECT (either by another view or a SQLEXEC) to search for the data for your DBF when you need it (i.e. bring spesific results each time thay are needed

Arnon