Re: Performance issue

Hi Jialiang Ge

Thanks for your reply.

The Malldoc template is located localy and is only 52kB small.
The loading of the template takes less than a second and is executed just
before in the code I supplied earlier. Up till we timed the opening I also
considered network load, but thats not the issue.

The clients are 32-bit PCs running Windows XP SP2 with Office XP (2002) SP3.

In an overall comparement some clients creates documents on 5-7 seconds,
while others use almost 2 minutes with the exact same conditions. This part I
supplied in my first post is the one with the biggest timeloss.
We have also checked other loaded COM Addins, and if we unload them we get
an increase in performance but we do not reach under 30 seconds for creation
of a document.

I guess, as you also suggest, that we have to narrow the debugging down even
more to logg every line of code in this part of the process.
I will talk to the client and discuss the logging increase. Then I will get
back to you.


Regards
--
Peter Karlström
Midrange AB
Sweden


"Jialiang Ge [MSFT]" wrote:

Hello Peter,

In my best guess, it is because Maildoc was having trouble to access its
attached template in the code:
wrdApp.Windows(Malldoc).Document.AttachedTemplate.AutoTextEntries("Standard1
").Insert Where:=rngHeaderFirstPage

Where is the template file located? Is it in a network share? Any chance
that the network connection of the five computers is causing the problem?
To verify this hypothesis, we can either use Procmon.exe to trace the
hanging period, or create a "Maildoc" from a local copy of the template and
see if the add-in can run smoothly based on this new "Maildoc".

If it does not help, would you tell me the Office & OS (64bit?) version of
the computers? It was mentioned that you used log to trace the operations.
Is it possible for you to detect the exact line of code that hangs in your
code snippet? You may consider splitting some long code lines into small
fragments, and log the operation time for each piece. For example:

Set doc = wrdApp.Windows("maildoc.doc").Document
log here
Set tmp = doc.AttachedTemplate
log here
Set entry = tmp.AutoTextEntries("Standard1")
log here
entry.Insert rngHeaderFirstPage True
log here

Regards,
Jialiang Ge (jialge@xxxxxxxxxxxxxxxxxxxx, remove 'online.')
Microsoft Online Community Support

Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
msdnmg@xxxxxxxxxxxxxx

==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.


.

Relevant Pages

  • RE: RPc server is unavailable since SP1
    ... I finally called Tech Support and we found out that there is a hotfix out ... In the Launch and Activation Permissions area, ... > IV. Please change permissions on the Workstation Authentication template to ... > that you want to autoenroll) enable autoenrollment by navigating to the ...
    (microsoft.public.windows.server.sbs)
  • Re: .Net system service??
    ... Template. ... Writting Windows Service in Win32 is a complex job, ... Microsoft Online Community Support ... where an initial response from the community or a Microsoft Support ...
    (microsoft.public.dotnet.framework)
  • Re: Performance issue
    ... Where is the template file located? ... Microsoft Online Community Support ... You can send feedback directly to my manager at: ... where an initial response from the community or a Microsoft Support ...
    (microsoft.public.office.developer.com.add_ins)
  • RE: GridView ITemplate Columns
    ... As for the custom TemplateField's Item/EditTemplate, ... add the custom template or the TemplateField in to GridView.Columns ... Microsoft MSDN Online Support Lead ... where an initial response from the community or a Microsoft Support ...
    (microsoft.public.dotnet.framework.aspnet.webcontrols)
  • Re: WSS V3 - Is it possible to set default versioning limits?
    ... And then save the list as template. ... Microsoft Online Community Support ... where an initial response from the community or a Microsoft Support ... project analysis and dump analysis issues. ...
    (microsoft.public.sharepoint.windowsservices)
Loading