Problem using Report Control 9.80 in VB6 +20K rows

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

Hello People.

I have a
big problem using Report Control 9.80 in VB6.

I�m trying to
load more than 20.000 rows, with 40 columns aprox, and the first time of
loading, the response is quick and acceptable, but in the same instance of the
form, in others words, without closing the form, when I get unloaded the 20.000
rows, loading, for example, 100 rows and then trying to load the same 20.000
rows, it spend to much time (second load is aprox. two times more slowly than the
first one, and I think it is increasingly this problem, because it gets bigger
the time I wait to get a response, every time I repeat this action, to load the
20k I mean) .

The only
way make it work normally again, is to close the form and open it again.

Thanks so much for the help.

This is the
code to destroy the rows and columns that I use. 

wnd.GroupsOrder.DeleteAll

wnd.Columns.DeleteAll

wnd.PaintManager.ShadeGroupHeadings
= False

wnd.Records.DeleteAll

wnd.PaintManager.NoItemsText
= "No Existen Registros"

wnd.Populate

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
pcmaker Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 05 May 2005 Location: Venezuela Status: Offline Points: 23	Post Options Post Reply Quote pcmaker Report Post Thanks(0) Quote Reply Topic: Problem using Report Control 9.80 in VB6 +20K rows Posted: 12 August 2008 at 6:40pm
	Hello People. I have a big problem using Report Control 9.80 in VB6. I�m trying to load more than 20.000 rows, with 40 columns aprox, and the first time of loading, the response is quick and acceptable, but in the same instance of the form, in others words, without closing the form, when I get unloaded the 20.000 rows, loading, for example, 100 rows and then trying to load the same 20.000 rows, it spend to much time (second load is aprox. two times more slowly than the first one, and I think it is increasingly this problem, because it gets bigger the time I wait to get a response, every time I repeat this action, to load the 20k I mean) . The only way make it work normally again, is to close the form and open it again. Thanks so much for the help. This is the code to destroy the rows and columns that I use. wnd.GroupsOrder.DeleteAll wnd.Columns.DeleteAll wnd.PaintManager.ShadeGroupHeadings = False wnd.Records.DeleteAll wnd.PaintManager.NoItemsText = "No Existen Registros" wnd.Populate

Oleg Members Profile Send Private Message Find Members Posts Add to Buddy List Senior Member Joined: 21 May 2003 Location: United States Status: Offline Points: 11234	Post Options Post Reply Quote Oleg Report Post Thanks(0) Quote Reply Posted: 13 August 2008 at 1:35am
	Hi, Think you need update. In last versions added Batch methods to add and remove rows.
	Oleg, Support Team CODEJOCK SOFTWARE SOLUTIONS

pcmaker Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 05 May 2005 Location: Venezuela Status: Offline Points: 23	Post Options Post Reply Quote pcmaker Report Post Thanks(0) Quote Reply Posted: 22 August 2008 at 4:19pm
	Hi oleg. Thanks, I�m update to V.12 and the problem was solve. Now, I need help with this "Batch methods" that you commented. If you can post any example code, I appreciate. And Thanks again.

AndreiM Members Profile Send Private Message Find Members Posts Add to Buddy List Moderator Group Joined: 18 August 2007 Status: Offline Points: 132	Post Options Post Reply Quote AndreiM Report Post Thanks(0) Quote Reply Posted: 23 August 2008 at 9:06am
	Hi, To enable Batch allocations (and custom heap) you have to add 2 lines in Form_Initialize handler: Private Sub Form_Initialize() ReportControlGlobalSettings.UseBatchAllocation ReportControlGlobalSettings.UseReportCustomHeap End Sub I also create sample (it will be added to our Extended samples): uploads/20080823_085346_ReportBatchAllo.zip NOTE: For Windows XP custom heap optimization works in full mode only without debugger. I mean that for tests of memory using better build and run EXE file to get more real results.