Article ID: 176435 - Last Review: May 13, 2003 - Revision: 2.0

PRB: Compiling to Native Code Can Be Slow

View products that this article applies to.
This article was previously published under Q176435

On This Page

Expand all | Collapse all

SYMPTOMS

When compiling a large project to native code, especially with optimizations selected, the compile time may be so long as to give the appearance of having "hung" the machine. Because there is no status bar to indicate the progress of the compiler, the only indicator available is to watch for hard drive activity, which may only occur once or twice a minute as this is a CPU intensive activity.
Back to the top

CAUSE

This is by design. Compiling to native code takes more time than compiling to p-code. There are some techniques suggested below for taking advantage of some Visual Basic language features to speed up compile time.
Back to the top

MORE INFORMATION

Using the techniques outlined below can result in significantly faster compile time. In some cases it has reduced compile time for large projects from over an hour to less than 10 minutes.
Back to the top

Minimize the Dots

When referencing objects in Visual Basic, you use the dot syntax '.' to navigate an object's hierarchy of collections, objects, properties, and methods. It is not uncommon to create very lengthy navigation strings. For example: 
   ' Refers to cell A1 on Sheet1 in the first workbook
   ' of an Microsoft Excel spreadsheet.
   Application.Workbooks.Item(1).Worksheets.Item_
   ("Sheet1").Cells.Item(1,1)
In addition to being a rather lengthy string to type, this line of code is fairly difficult to read and it is extremely inefficient.

The compiler must resolve each dot every time a dot is encountered. To write applications that compile quickly, minimize the use of dots when referencing an object.

You can usually minimize the dots by analyzing the objects and methods available to you. For example, the above line of code can be shortened by removing the Item method (this is the default method for collections anyway, so you'll rarely use it in code) and by using the more efficient Range method: 
   ' Refers to cell A1 on Sheet1 in the first workbook
   ' of an Microsoft Excel spreadsheet.
   Application.Workbooks(1).Worksheets("Sheet1").Range("A1")
You can shorten this even further by rewriting the code so that it refers to the active sheet in the active workbook, instead of a specific sheet in a specific workbook: 
   ' Refers to cell A1 on the active sheet in the
   ' active workbook.
   Range("A1")
Of course, the above example assumes it's OK to refer to cell A1 of any sheet that happens to be active.
Back to the top

Use Set and With...End With

Using the Set statement also allows you to shorten navigation strings and gives you a bit more control over your code. The following example uses the Dim and Set statements to create variables that refer to frequently-used objects: 
   Dim xlRange As Object
   Set xlRange = Application.ActiveSheet.Cells(1,1)
   xlRange.Font.Bold = True
   xlRange.Width = 40
Visual Basic provides the With...End With construct to set an implied object within code: 
   With Application.ActiveSheet.Cells(1,1)
      .Font.Bold = True
      .Width = 40
   End With
Back to the top

REFERENCES

Books Online, Programmer's Guide, Optimizing Objects
Back to the top
APPLIES TO
  • Microsoft Visual Basic 5.0 Learning Edition
  • Microsoft Visual Basic 6.0 Learning Edition
  • Microsoft Visual Basic 5.0 Professional Edition
  • Microsoft Visual Basic 6.0 Professional Edition
  • Microsoft Visual Basic 5.0 Enterprise Edition
  • Microsoft Visual Basic 6.0 Enterprise Edition
Back to the top
Keywords: 
kbprb KB176435
Back to the top
 

Get Help Now

Contact a support professional by E-mail, Online, or Phone

Article Translations