>I must be missing something. You are the third person that has made a reference to using parameters in the view. I am using a field that is indexed and when I requery() (that uses the index parameter) the file it comes back in a few seconds because it retrieves on the index field. My problem is when I update the table using tableupdate(1). It is so slow that I wonder if it is trying to reindex the file. Just joking!!!. But it is very slow sometimes taking minutes. So the question is --- Am missing something (like somesort of switch or parameter) to speed up the tableupdate function?????
>
>John


I have two suggestions :
1 - If your backend table primary key index clustered, make non clustered.
2 - Try increasing the (NUMBER OF RECORDS TO BATCH UPDATE) of the view.