Walter Meester
HoogkarspelPays-Bas
Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Please let me know if this would be a good idea in reference to tables and views. I have a table with about 100,000 records and potentially more containing information about subscribers. These subscriber subscribe thru one of three cities. I need to create a lookup screen that has three option button one for each city. When the user click the city button the lookup grid refreshes. I tried both using a view and a filter and found that you are correct in the fact that in the case views are slower. After the user locate the correct subscriber I need to pull in from multiple table information regarding that subscriber. So in this case the result set would be small. Would this be a good use for a view. Please let me know what your ideas are about this.
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