Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Improving View Update Performance in a Grid
Versions des environnements
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement