For those who want the same see post

 

 

I knew in advance that the virtuallist couldn't be sorted, this isn't an issue. I was just explaining to my fellow CJ users how fast you can display a hugh amount of data.

 

When assigning values to an array you don't have to put so much effort in it:

 

 

fnum = FreeFile
Open strFile For Input As fnum
wholeFile = Input$(LOF(fnum), #fnum)
Close fnum

 

lines = Split(wholeFile, vbCrLf)
numberOfRows = UBound(lines)
    
totalNumberOfRows = totalNumberOfRows + numberOfRows
    For R = 0 To numberOfRows - 1
        arrayItems(R) = Split(lines(R), ",")

    next R

 

Done..... 65000 records loaded in 1 second (800Mhz machine) and ready to use for the ReportControl. The tests I did with the 1,5 million records I did in the office (3.1 Mhz and lots of memory )

 

 

I use the Ado CSV connector for many of my softs in vb6 and the recovery of the recordset is rather fast even for hundreds of thousand lines.

 

Once you have the recordset the order is easy.

 

In fact, I do not see what CodeJock can make to by-pass the problem. The virtual mode imposes this kind of limitations i think.

 

I load the rows from a file (csv) into an array, not from a database. When loading the rows into a recordset its taking a lot longer. You will have sorting thats true. I will have a look at it in the near future.

 

Thanks anyway

 

I did some tests with ReportControl's VirtualList. I would say this is a great control if you want to load lots of data. My app generates an event for every action and will be saved in a csv file. 

 

Loading about 1000 files (contains 1,5 million rows with 11 cols) in 16 seconds, thats about 95.000 records in one second  

Internal memory decreased about 700 Mb, minor problem these days  

 

The rows will be loaded into an array and with the BeforeDrawRow shown to the user. Then the user wants to do a search operation in the super listview and plop in 0,0001 seconds the ReportRecordItem area will be painted in a color he/she selected and this with 20 search items at one time

 

I know its only virtual but the user doesn't hahaha. Great !!!

 

The only negative about the virtual list: you cannot sort items! Or you have to do the sorting within your array but that will take more time and we don't want that

 

 

 

 

 

Suppose, I have a table in database which contains about 1 million records, and I want to load the data into the report control. Do I have to add one record at a time to the report control or the entire table? And afterwards I can navigate through the items?

 

Thanks in advance

 

When I looked at the sample where the reportcontrol is used in virtualmode and filling the list with lets say 1 million records in uhhh 1 second?!?! I thought wow!!!! This is what I need

 

But there's always a catch, I thought to myself. Is there? I'm currently using a listview to fill a large amount of records from a database. I don't know with which of the controls will have the best performance: Reportcontrol or Listview. Can someone tell me this? Maybe someone did a test with these controls, so a sample would be great of course, just to see the difference (in performance) between the 2 controls.

 

Thanks in advance