Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
I have doing some testing on the this problem. It seems that where the problem really exist is when I refresh the grid on the small result set. Everything seems to be fine on the larger sets. This application needs to be really fast since it is a system in which users are taking orders over the telephone and they will bark if it isn't fast. I've tried using view but that is too slow and I don't think an SQL statement would be any faster. Instead I being thinking of maintaining separate lookup table for each area. When they select an area I would refresh the grid. Does that sound like a better approach. From what I can figure out that when the grid refresh on the small set it must go thru the entire table? I'm not really sure what happens there. Thanks
Précédent
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