Hello all.
The events of today have me scratching my head. I have a database that is 11k Front end (After compact and repair) and 180k Be (After compact and repair). The main form the users use to check in samples and enter results etcis chock full of fields and is two pages basically. It has had some problems being very slow and using a query and some resturcturing I was able to speed it up considerably. On Monday I was asked to make some changes to a message box that pops up when they want to print some reports. I made the changes and updated and the form took literally 3-4 minutes to open, sometimes more. I was baffled. I made some other changes at that time also. So I went to a backup copy that was fast and did all of the changes that I made on that goaround and found that the code that was slowing it down was this message box. WHY??? I could leave the message box there I just had to take out the line breaks and it sped right up to instant display. Why would this little bit of code slow my Form so drastically? Is there some sort of size limit that I just passed, some sort of cache that is too full? Does anyone have any idea? Thank you for listening to me after a bizarre day.
-Greg
The events of today have me scratching my head. I have a database that is 11k Front end (After compact and repair) and 180k Be (After compact and repair). The main form the users use to check in samples and enter results etcis chock full of fields and is two pages basically. It has had some problems being very slow and using a query and some resturcturing I was able to speed it up considerably. On Monday I was asked to make some changes to a message box that pops up when they want to print some reports. I made the changes and updated and the form took literally 3-4 minutes to open, sometimes more. I was baffled. I made some other changes at that time also. So I went to a backup copy that was fast and did all of the changes that I made on that goaround and found that the code that was slowing it down was this message box. WHY??? I could leave the message box there I just had to take out the line breaks and it sped right up to instant display. Why would this little bit of code slow my Form so drastically? Is there some sort of size limit that I just passed, some sort of cache that is too full? Does anyone have any idea? Thank you for listening to me after a bizarre day.
-Greg
