Solved

Which is more efficient, Procedures on a form or in a module

Posted on 2004-08-27
4
241 Views
Last Modified: 2010-04-17
I have a very large module (.bas) containing maybe 40 procedures. I third of these pertain to reports. Would it be more efficient to have the report procedures moved to the Form used for reports?

When A procedure in a .bas is executed, does the whole .bas get loaded into memory?



Sorry I only have 40 points!
0
Comment
Question by:hrogers
4 Comments
 
LVL 5

Accepted Solution

by:
rsriprac earned 40 total points
ID: 11918665
>I have a very large module (.bas) containing maybe 40 procedures. I third of these pertain to reports. Would it be more efficient to have the report procedures moved to the Form used for reports?

Yes if some form is used more infrequently then others, it is worth doing so.

>When A procedure in a .bas is executed, does the whole .bas get loaded into memory?

Yes, the whole module is loaded when a routine is called upon.

-RAm
0
 
LVL 3

Expert Comment

by:aravindtj
ID: 11921600
Use modules. It is loaded in memory only once.
It can be reusable by another methods.

Using modules is a better way.

All the best.
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Displaying an arrayList in a listView using the default adapter is rarely the best solution. To get full control of your display data, and to be able to refresh it after editing, requires the use of a custom adapter.
This article will inform Clients about common and important expectations from the freelancers (Experts) who are looking at your Gig.

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question