General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Improving View Update Performance in a Grid
Environment versions
Network:
Windows 2003 Server
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only