>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

Hey John,
Sorry to take so long...

I have experienced something simmilar but not the the extent you are.
It happened when we upgraded our servers from Novell 3.1 to 4.0. I don't know if it is because Novell 4.0 uses data compression, but our file updates are much slower than reads now. However, we don't experience the delay you are seeing.
You might look at your server and up its memory or CPU.

Another thought is the level of buffering you are using on the view and/or the base table(s). Table level buffering will take longer than row level and may not be necessary unless you are viewing/editing in a grid, etc.

Also, if your view accesses mutiple tables, make sure you only specify the required tables as updatable in your view.

Further, if you are buffering your view, you can turn off the buffering of its base table. Not doing so requires a tableupdate of the base table as well.

Hope it helps.
Steve