Solved

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

Posted on 2004-08-27
4
245 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

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

A short article about problems I had with the new location API and permissions in Marshmallow
What do responsible coders do? They don't take detrimental shortcuts. They do take reasonable security precautions, create important automation, implement sufficient logging, fix things they break, and care about users.
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …
Progress

630 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