OLE performance tips
If your script (mainly ASP) works with OLE objects, the creating of
these objects can spend a lot of time. You can do some additional
steps to impove the performance speed of the script. These are the
most common recomendations, not more.
- Try to use Server.CreateObject instead of CreateObject.
This will be faster. But if the object requires additional
uninialization (maybe objects are coming from .EXE files rather then
from .DLLs), this method is unacceptable. MS Office applications objects
requires uninitialization ('Quit' method). See the corresponding
application manual for details.
- Use statically allocated OLE objects instead of dynamic
recreation.
Use Application_OnStart function in your global.asa
file to create an object in the application valiables, and Application_OnEnd
method to call appropriate object shutdown methods. See your ASP manual
for details.