>Hello,
>
>I have a form which contains three different grids for a child table. Each grid's rowsource is a different view for the same child table. The view takes the parent record's key value as a parameter. The child table has almost 800,000 records.
>
>In the grids, the users can manually edit a 255 character field and then move off of the record in the grid. I'm noticing a lag in the screen refresh when the user changes the field value and moves off of the current record. I'm assuming the lag is caused by the view's update.
>
>The child table that the views are based upon are indexed on every field other than the one being updated, and I can't index that one since it's over 240 characters. I've set the Optimize property to .T. in the grid.
>
>Can anyone think of any other way to speed up the view's refresh and minimize the delay when moving off of a changed record in the grid?
>
>Thanks in advance,
>
>Ben
What buffering you used?
I suspect you use the default, Row buffering for that view. Change it to Table Buffering and have one SAVE button that will save your changes. Also what is the SQL Where clause defined for your views?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.