how to trace time required to get data in view from dataenvironment

[Nifrabar]

Hi!
I am having a form with dataenvironment in which 10 views.
I have not set for every view the nodataonload.
As it should be monitored what time is required by which view before data is available in view: how can I trace that.

Now the form takes a number of seconds (over 5) before form is displayed. So I consider to set all nodataonload and requery whenever a view is required within the form 1st time.

TIA
-Bart

 

[Nifrabar]

Mike,
Thanks for reply.
What is advantage of not using DE but Load method instead?
-Bart

 

[Nifrabar]

Mike,
Thanks for explanation.
Certain some advantages.
-Bart

 

[Olaf Doschke]

disadvantage is, you don't inherit from DE properties, for example I'm thinking about the BufferModeOverride set to 1 and thereby having an easy way to influence buffering for all DE tables/views via Form property. It's not a big advantage anyway, as you might want to set buffering explicitly to some mode anyway. And DE's InitialSelectedAlias can also be done by a simple SELECT somealias in code instead of setting this on the DE object.

In fact I don't know of a big deal of any setting or behaviour of the DE and it's cursor objects that will save you wrinting lots of code. AutoCloseTables = .T. , well do a CLOSE TABLES ALL in form unload. In fact without using the DE you have one less pain of the path to the dbc stored in the cursor objects. With USE in code you _can_ use an explicit path, but you can also USE databasname!tablename.

All in all the DE isn't of much help if you know your foxpro commands.

Bye, Olaf.