>In order to load my forms as quickly as possible, I am trying to use views instead of the actual tables. But the views don't seem to be loading quickly!
>
>I've marked all of my views as NoDataOnLoad in the DataEnvironment but they still take a long time to open. Why would the statement USE MyView NODATA take a long time to execute?
>
>Here is a sample view:
>
>SELECT Table1.LinkField,Table1.Field1,Table1.Field2, ;
> Table1.Field3, Table1.Field4, Table1.Field5 ;
>FROM Table1;
> INNER JOIN Table2 ;
> ON Table2.SeqNo=Table1.LinkField ;
> WHERE Table2.Id="123"
>
>According to the SYS(3054) function, everything is optimized. I have DELETED() tags on both files. I have tags on Table2.SeqNo and Table2.Id. Why should this SELECT seem to take forever? What can I do to speed it up? This is only one of several views I need to open and requery.
>
>Thanks!
>Elyse
How many records you expect to get in the recordset? What is destination of this view? Grid?
Edward Pikman
Independent Consultant