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.
Graphic time refresh with ado recordset
-
- Site Admin
- Posts: 14730
- Joined: Mon Jun 09, 2003 4:00 am
- Location: Banyoles, Catalonia
- Contact:
Hi alainv,
Please post your project at news://www.steema.net/steema.public.attachments newsgroup.
Thanks in advance.
Please post your project at news://www.steema.net/steema.public.attachments newsgroup.
Thanks in advance.
Best Regards,
Narcís Calvet / Development & Support Steema Software Avinguda Montilivi 33, 17003 Girona, Catalonia Tel: 34 972 218 797 http://www.steema.com |
![]() ![]() ![]() ![]() ![]() ![]() |
Instructions - How to post in this forum |
-
- Site Admin
- Posts: 14730
- Joined: Mon Jun 09, 2003 4:00 am
- Location: Banyoles, Catalonia
- Contact:
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.
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.
Best Regards,
Narcís Calvet / Development & Support Steema Software Avinguda Montilivi 33, 17003 Girona, Catalonia Tel: 34 972 218 797 http://www.steema.com |
![]() ![]() ![]() ![]() ![]() ![]() |
Instructions - How to post in this forum |
-
- Site Admin
- Posts: 14730
- Joined: Mon Jun 09, 2003 4:00 am
- Location: Banyoles, Catalonia
- Contact:
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.
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.
Best Regards,
Narcís Calvet / Development & Support Steema Software Avinguda Montilivi 33, 17003 Girona, Catalonia Tel: 34 972 218 797 http://www.steema.com |
![]() ![]() ![]() ![]() ![]() ![]() |
Instructions - How to post in this forum |
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
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
-
- Site Admin
- Posts: 14730
- Joined: Mon Jun 09, 2003 4:00 am
- Location: Banyoles, Catalonia
- Contact:
You're welcome AlainV,
Please be aware at those forums for next versions releases and its release notes.
Please be aware at those forums for next versions releases and its release notes.
Best Regards,
Narcís Calvet / Development & Support Steema Software Avinguda Montilivi 33, 17003 Girona, Catalonia Tel: 34 972 218 797 http://www.steema.com |
![]() ![]() ![]() ![]() ![]() ![]() |
Instructions - How to post in this forum |