Milt,

How many records does the SQL statement return ? 121.000 records ? or is it returning a subset of those 121.000 records ?

Walter,


>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