Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (1)

Resolved Performance Issue with OLE Document Preview

  1. Advice
0
Votes
Undo
  1. Shawn Davis
    Shawn Davis
  2. PowerBuilder
  3. Sunday, 23 April 2023 23:36 PM UTC

Hello,

We a have an interesting performance issue. We have a datawindow of records relating to Word documents (stored in a blob column). When we click on a record another area of the screen uses an ole control to preview the document. We've been chasing our tails on preview performance issues that are sometimes almost instantaneous and other times can take 2-8 seconds. So, we've finally discovered where the delay is coming from, Word.

If Word is already open, preview is instantaneous, if not, 2-8 seconds. Obviously, we could advise users to keep Word open at all times but that seems a bit inelegant.

Anyone have any ideas?

Thx,

Shawn

 

 

  1. Office
  2. OLE
  3. PowerBuilder (Appeon)
Datawindow print size not in printer
How do I add a structure to a Custom NVO
Responses (1)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Monday, 24 April 2023 01:39 AM UTC
  2. PowerBuilder
  3. # 1

Hi Shawn;

   Suggestion: You could use something like the FindWindowW() SDK function to see if MS-Word is running. If not, alert the App user that the display will be delayed while MS-Word starts up.

Regards ... Chris 

Comment
Shawn Davis
  1. Shawn Davis
  2. Monday, 24 April 2023 17:44 PM UTC
The only problem is that now we have frustratingly slow preview. Any way to open just the Word engine without opening it manually, warm the engine so to speak.
  1. Helpful
Shawn Davis
  1. Shawn Davis
  2. Monday, 24 April 2023 18:23 PM UTC
Maybe we could instantiate a word.ole control at the app level and activate inplace but have the control be invisible?
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.