>>>I just created an empty form based on the VFP base class, added 5 files to DE, and saved, then MODIFY FORM took around 6-7 sec. Removing one table at a time, the opening time decreases by ~1 sec, when there is no table in DE it takes less than 1 sec.
Hmm...I'm not finding any delay at all for MODI FORM with a busy DE. I added 25 tables of varyiny types - small, medium, large (large in different respects - number of fields, records, tags, and a very large DBC). I added DE-based textboxes to fill the form. No speed hit at all, even after a Restart and then doing a MODI FORM first to rule out caching.
However, these are all local-drive tables I'm testing, just to make sure there is nothing wrong *specifically* with MODI FORM, and I don't think there is.
Have you tested this way, Doru? I'm still thinking your problem is somehow network-related, as I said in my first post...
And if it is, the solution should be simple: make an exact copy of the entire DBC and all files to a local drive for development, perhaps reducing #records in big tables, if there's any space problem. That's the way I almost always develop (depending somewhat if I'm sharing files/updates with other developers):
1) Early stage: all files on local drive
2) Mid-stage: most files on test server
3) Final stage: most files on production server
(DB portability is one of the great attributes of vfp, of course.)
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.