Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Yes that exactly how my code looks. I am trying to retrieve one record with about 10 fields in the view definition. I have an index based on trimming the id - could that be a problem. Potentially I will be pulling in even more fields from related tables and feel that if this is a problem at this level maybe I should not be using local views. This is my first experience using view and need some advice on when it is appropriate to be using views. My application is using native FoxPro tables. This is an telephone application in which users must be able to access the information very fast. My recordset is about 121,000 records and it takes about 8 tenth of second on my 600 mhz machine to requery the view - however user don't have as powerful machine as I do. Also all my testing has been done on my local machine what can I expect when I put this on the network.
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