Performanceproblem with OnBeforeDrawRow

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   Hi, 

when using virtual mode (we need to use this mode, because there are > 10000 Rows) under Visual DataFlex I have the problem, that navigation is quite slow (Pentium 4, 2.5 Ghz). The more columns and rows I have, the slower it is. Maybe, it's much slower mit VDF than with VB.NET, but OnComBeforeDraw seems to be called too much times. Is there another method for updating the items? Can Codejock implement an event, that is only called for items really need to be updated?
Actually it isn't useable for us.

Regards,

Ren� Jungmann

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
RJungmann Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 05 February 2008 Status: Offline Points: 13	Post Options Post Reply Quote RJungmann Report Post Thanks(0) Quote Reply Topic: Performanceproblem with OnBeforeDrawRow Posted: 02 June 2009 at 8:39am
	Hi, when using virtual mode (we need to use this mode, because there are > 10000 Rows) under Visual DataFlex I have the problem, that navigation is quite slow (Pentium 4, 2.5 Ghz). The more columns and rows I have, the slower it is. Maybe, it's much slower mit VDF than with VB.NET, but OnComBeforeDraw seems to be called too much times. Is there another method for updating the items? Can Codejock implement an event, that is only called for items really need to be updated? Actually it isn't useable for us. Regards, Ren� Jungmann
	Product: Xtreme SuitePro (ActiveX) version 12.0.2 Platform: Windows XP (32bit) - SP 2 Languages: Visual DataFlex 2008 (VDF 14.0), VB.Net 2008 (Express)

Aaron Members Profile Send Private Message Find Members Posts Add to Buddy List Senior Member Joined: 29 January 2008 Status: Offline Points: 2192	Post Options Post Reply Quote Aaron Report Post Thanks(0) Quote Reply Posted: 02 June 2009 at 2:13pm
	Hi, What code do you have in BeforeDrawRow event? I did test once (See post https://forum.codejock.com/forum_posts.asp?TID=9554) and I didn't notice any delay when navigating report items. I'm also using BeforeDrawRow event to build markup strings for showing tooltips (well in this case I only have about 7.000 rows and 12 columns and load them directly into records) but every time RC needs to be redrawn, all the markup strings have to be generated... If you resize RC and it shows only, let's say 2 rows, do you still have slow navigation? In this case BeforedrawRow event will fire only 2 times the number of cols in RC, in other words: Only those items which are visible at that time, so I can't imagine that it will take that much time to redraw RC items??? I can't test your code so I can't tell you anything more than I did already. Well good luck with it... And maybe you have to consider to load data just as ordinary records (I don't see why you use virtual mode for 10.000 records, see my post again )
	Product: Xtreme SuitePro (ActiveX) version 15.0.2 Platform: Windows XP (32bit) - SP 2 Language: Visual Basic 6.0 Zero replies is not an option....

RJungmann Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 05 February 2008 Status: Offline Points: 13	Post Options Post Reply Quote RJungmann Report Post Thanks(0) Quote Reply Posted: 05 June 2009 at 4:40am
	Hi, I have to use virtual mode. In my tests the performance goes down more and more when having more than 2000-3000 rows. And there are situations, where I have more than 30.000 rows. I could sent you the code, but it is Visual DataFlex. But maybe you could find a general mistake in it. Regards
	Product: Xtreme SuitePro (ActiveX) version 12.0.2 Platform: Windows XP (32bit) - SP 2 Languages: Visual DataFlex 2008 (VDF 14.0), VB.Net 2008 (Express)

Aaron Members Profile Send Private Message Find Members Posts Add to Buddy List Senior Member Joined: 29 January 2008 Status: Offline Points: 2192	Post Options Post Reply Quote Aaron Report Post Thanks(0) Quote Reply Posted: 05 June 2009 at 11:00am
	Hi, I can always have a look at it and maybe other DataFlex users can test your code as well. Just show me how you load data an d code in BeforeDrawRow event.
	Product: Xtreme SuitePro (ActiveX) version 15.0.2 Platform: Windows XP (32bit) - SP 2 Language: Visual Basic 6.0 Zero replies is not an option....

Trik_tango Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 17 February 2009 Location: Italy Status: Offline Points: 1	Post Options Post Reply Quote Trik_tango Report Post Thanks(0) Quote Reply Posted: 16 June 2009 at 5:49am
	Hi Ren�, i'm a VDF developper if you share your code i try to help you Regards Renato Villa