Graphic time refresh with ado recordset

alainv · Post by **alainv** » Fri Jun 16, 2006 2:50 pm

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.

Narcís · Post by **Narcís** » Fri Jun 16, 2006 3:01 pm

Hi alainv,

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

Thanks in advance.

Narcís · Post by **Narcís** » Tue Jun 20, 2006 8:38 am

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.

Narcís · Post by **Narcís** » Tue Jun 27, 2006 8:39 am

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.

alainv · Post by **alainv** » Tue Jun 27, 2006 3:51 pm

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

Narcís · Post by **Narcís** » Wed Jun 28, 2006 9:58 am

You're welcome AlainV,

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