How do I get program to talk to me during execution

My blank form calls a mysql stored proc that calls another and another depending on some variables. It can take some time to run. I’m getting an internal server error if it takes too long. Even if it runs through correctly till the end, none of my other menu choices are available during that time. I’ve changed timeouts to as long as you can set them. I have no idea how to deal with this. Ideas?

here a post about your question

You can anayize yours queries:

Yeah, it’s not the queries. Thanks…will continue to experiment.