General information
Category:
COM/DCOM and OLE Automation
Does anyone have any ideas why Microsoft Graph 8 is so slow? I have it instantiated and formatted as I would like it on a form. The form opens - no problem, but as soon as the code fires to bring the graph up to date, my disk goes into overdrive and I have to wait until the graph wakes up.
Once the intial wake up period is over, the update speed isn't too bad (could be better) but its this initial time out that is the real pain and fustration to the users.
Here's the update code. It may help someone to see what's wrong.
(It only goes to sleep during the first up date)
lnPressRow = 1
lnTempRow = 2
lnColCtr = 1
with this.olePTGraph
scan
lnColCtr = lnColCtr + 1
.Worksheets("Sheet1").cells( lnPressRow, lnColCtr ).value = PressBarg
.Worksheets("Sheet1").cells( lnTempRow, lnColCtr ).value = Temp
endscan
lcColLtr = chr( dnLetterA + lnColCtr - 1 )
.Charts("Chart1").SetSourceData( .Worksheets("Sheet1").Range("a1:" + lcColLtr + "2"))
endwith
Better still, I would appreciate if anyone could point me in the right direct for a better solution (preferably free) which is faster and stable withing FoxPro.
Any ideas would be most welcome
Jason
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only