Hey all

Let me start by saying, I've been using this technique in Visual MaxFrame a long time. I would like any extra information that I can get on this approach though.

I just conducted a little experiment. I believe FoxPro obtains a file handle and then fills internal buffers when it first sees a USE command.

If so, then a form with a private data session, which opens tables will take the same amount of time every time and within reason that is true.

However, if I open the tables in the default data session before the private data session form loads, the form itself loads much faster.

I created a simple private datasession form. The load opens the tables. The init returns .f.
I ran a loop of 50 iterations with DO FORM. It took 120+ seconds.

I then opened the tables first and re-ran the 50 iterations. It took 10 seconds.

In side the form, USED() shows the files are not in use, yet clearly, the file handle and buffers were populated.

So - who can state with authority, what will happen to the data, if in the private data session form, a change is made and tableupdate is run? Will the data make it physically to the file or does it hang around in the buffer?

If power goes off, does the data get wiped out?

Having all the tables opened, does not damage the files during a power failure in my experience. Anyone care to shed some light on this?

Thanks