Rex,
You really should have indexes on these fields. When a local view is used to update a table, it does a SQL UPDATE command to update the table. Something like:
UPDATE mytable ;
SET MyField1=x, MyField2=y ;
WHERE KeyField=updatedrecordskeyvalue
Without an index it has to scan the whole table looking for the right record for each update.
>Hi Josh,
>
>I have indexes, but not on the primary key fields
>
>Rex
>
>>Rex,
>>
>>Do you have indexes on the field(s) that make up the primary key for the underlying table?
>>
>>>All,
>>>
>>>I have an application that uses a view. I open the view NODATA and set buffering to optimistic table buffering add some indexes and requery the view..
>>>
>>> I then allow the user to select records and I replace a flag field and print the records. I then replace several fields in the view with pertinent information for all selected records. During this replace, for each record, the view requeries. It takes 120 seconds ro update one record and then it goes to the next record and takes another 2 minutes and on and on...
>>>
>>>Has anyone seen this behavior???
>>>
>>>Thanks
>>>
>>>Rex