Page 1 of 1

Graphic time refresh with ado recordset

Posted: Fri Jun 16, 2006 2:50 pm
by 9526959
Hello,

I encounte some problems of graphic time refresh when i use ado recordset. The main problem is this one:
Every minute i take data in a data base using ado recordset and i reconnect the recordset on graph series same as you describe in different samples. And every minutes, the refresh time increase more and more, and after one hour, refresh time has increase to more than several seconds.
I encountered this problem in all kind of softwares i developped. So i suppose that i do or not do something, but after to have read all you helps and samples i don't see where is the mistake.
So i wrote a little software that show the problem. How can i send you ?
I use V7.0.0.4 of the OCX. I have read the news about the last version and i didn't see that the release can solve my problem.

Posted: Fri Jun 16, 2006 3:01 pm
by narcis
Hi alainv,

Please post your project at news://www.steema.net/steema.public.attachments newsgroup.

Thanks in advance.

Posted: Tue Jun 20, 2006 8:38 am
by narcis
Hi alainv,

Thanks for the example but I can't run it properly because VVModule1.bas module is missing. Could you please post it in the newsgroups as well or modify your example so that it doesn't use this module?

Thanks in advance.

Posted: Tue Jun 27, 2006 8:39 am
by narcis
Hi alainv,

Thanks for the example.

You are right, we could reproduce the problem here. In your example the refreshing time increases but this only happens using a for loop in the OnTimer event. It is not much usual updating a recordset 10 times every second. This means that usually refreshing a recordset, if this doesn't stop for a week, the time may have increased in 10 seconds.

There's no solution we can think of for now. I've added the issue (TA05011526) to our defect list to be investigated and fixed for future releases.

Posted: Tue Jun 27, 2006 3:51 pm
by 9526959
Hi Narcis

Thank you very much for your efficient support.
I'm happy that you could reproduce the problem.
Of course it's not usual to refresh 10 times the same graph on each occurence, but it was for the sample, to enlighten the probleme.

Hope you will find a solution soon because it's really embarrassing in software running 24/24h and refreshing data every minutes.

Good luck

AlainV

Posted: Wed Jun 28, 2006 9:58 am
by narcis
You're welcome AlainV,

Please be aware at those forums for next versions releases and its release notes.