Alex,
Take a look at the wiki web site:
http://fox.wikis.com/wc.dll?Wiki~NonDiscriminatingIndex~VFP"The important thing is not to trust SYS(3054), but to measure the
performance under real-world conditions. We found that opening a view
with NODATA, which should theoretically only pull a few bytes of
structure info over the network, was instead sucking multi-megabytes of
data through the wires, slowing performance to a crawl! The reason was
that Rushmore doesn't care about NODATA; it still pulls over the indexes
it thinks it will need to optimize performance. Removing the tag on
DELETED(), as well as a few other non-essential tags, made a huge
difference. -- EdLeafe"
>Hi!
>
>Is this at all possible? I think I found out why my forms take so long to instantiate the first time I run them.
>
>Even though the nodata clause is used for bringing the views in the bizobjs online, some querying does take place (acording to vfp help).
>
>Is there a way to delay this until I REALLY need the view to be activated?
>
>That's where the title of this thread comes from.
>
>Some of my bizobjs use rather complicated views that take long to even return an empty cursor and I think this is what's causing my forms to appear sloppy.
>
>Thanks!
>
>Alex
Hector Correa