>I posted this in the client server section, but I failed to mention that I am using ODBC to talk to my database. That slows stuff down too. :-(
>
>I guess there is no easy answer. My current process takes about 30 seconds per master record.
>
>I wanted to avoid the slow startup costs of loading every record from every table at the start of the program, but I figured that I would have to deal with each master record only taking under 10 seconds. Not a half a minute.
>
>I'll pay the overhead at the top of the program. Tell the users not to exit during the day... *sigh* another plan gone astray.

Yes, it's common knowledge here to avoid ODBC if at all possible, and use native data (e.g., vfp tables) where ever possible...

Perhaps you can make an attractive animated splash setup to engage users while they wait :)