Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Speed problems - getting desperate
Message
From
03/03/1999 18:06:05
Elyse Pomerantz
Dynamic Data Concepts, Inc.
Brooklyn, New York, United States
 
 
To
02/03/1999 10:10:26
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00192832
Message ID:
00193818
Views:
12
>Hi Elyse.
>
>>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?
>
>There was a tip in FoxPro Advisor a few issues back on this topic. If I recall, it's due to the way VFP handles SET DELETED when you open a view NODATA. Try SET DELETED OFF before opening the views NODATA, then SET DELETED ON; that seems to improve the time VFP takes to create the empty cursor.
>
>Doug


I don't understand why, but this helped tremendously! Now the views load instantaneously. Thanks!

Elyse
Elyse Pomerantz
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform