Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
I have the following situtation. I have a table of approximately 121,660 records which have a region field. It is populated with either WDC (Washington,D.C.) or SFB (San Francisco). The records from DC total 71,448 and 50,204. The remaining records are for Chicago approximately 5. On the screen I have a optiongroup that will set a filter for the different area. All seems to work well for WDC and SFB but I am having problems with Chicago. The code set the filter, does a locate and then refreshes the grid. On the Chicago selection when I try to refresh the grid it just takes forever. Is this because it has to navigate thru the table or what. Any suggestions.
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