Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Speed problems - getting desperate
Message
From
01/03/1999 15:06:04
Elyse Pomerantz
Dynamic Data Concepts, Inc.
Brooklyn, New York, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Speed problems - getting desperate
Miscellaneous
Thread ID:
00192832
Message ID:
00192832
Views:
51
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
Elyse Pomerantz
Next
Reply
Map
View

Click here to load this message in the networking platform