SOLVED: 100000 records or more!

Hi,

Hi,

The attached zip file contains a sample project with a smaller database than the one you provided (30000 records). I have only 256 Kb internal memory on this laptop  The name of the database stays the same, if you want to use your own database, just copy/paste it in the same directory as the project.

With this sample you can:

1. load a database table into the reportcontrol (2 different ways, DAO and ADO)
2. column names will be loaded from the table field names.
3. show properties of the selected record.
4. filter on selected column with entered filter text (not case sensitiv)
5. group selected column (and have still a filter as in 4.)
6. autosize columns on their contents.

If you have any questions, just let me know. Btw the database connection is maybe different than you normally do, but you can change that. I put in two options and it seems option 2 is just a little faster. Well check it out yourself. Good luck

Hi,

Hi,

• The counter will start only in the Loading records function and before this all records / columns are deleted, Database connection is made and all this takes some time more, thats why you think it's higher.
• It will always take time to load the records into the ReportControl, so instant is never the case
• If you change something in the reportcontrol you have to call populate in order to see the changes. But this isn't taking that much time. If you change or add a record you only have to call populate and save ONLY the changed / added record into the database and you don't have to load the records from the database again because they are already updated in the reportcontrol.
• Add a timer function to see how much time it takes to call .Populate (it's about 0,1 second for 30.000 in my case)
• I noticed you have a dialog for changing / adding records, it is possible to have inplace editing on subitems as well, maybe an option?

 

Hi,

Hi,

1. Sort columns with filter
2. Inplace editing on subitems (which are directly updated in the database table)
3. Get properties of selected record of database table
4. Access database directly
5. Tip: you can change the SQLString as you wish (now it's in the code but you could "build" your own sql string if necessary)

Hi,

if speed has first priority you can look at the attached sample: I added two new options. The first one ("Load from database 3") with ADO and the GetRows() method, the other uses the same method but with DAO ("Load from database 4").

uploads/20080610_111458_080610_Test_Rep.zip

I'm disappointed too that there is no DblClick() event for the ReportControl, but I needed it urgent, so I subclassed the ReportControl with the famous ssubtmr6.dll from vbAccelerator. Take a look in the attached files.



In addition to Aarons sample, I added the following options/features:

• The button "Load from database 3" uses ADO to connect to the database and instead of iterating through the recordset with method MoveNext it uses GetRows to retrieve all records at a time and stores it in a two dimensional variant array. It depends on the count of records how much memory  is used.
  
• The button "Load from database 4" uses DAO to connect to the database and uses the GetRows method too, but not all records at a time but rather 1000 records after another
• The Caption of a grouprow is extended by some information using the BeforeDrawRow event (see screenshot above)
• To capture ReportControl DblClick events I use a subclassing method provided by vbAccelerator
  

Please keep in mind that I'm pretty new with the ReportControl, so any suggestion is welcome.

Best regards, Peter

Product: Xtreme SuitePro (ActiveX) version 11.2.2/12.0
Platform: Windows 2K/XP/Vista (32bit)
Language: Visual Basic 6.0 SP6

Of course, the GetRows method needs a lot of memory, but under certain conditions ("if speed has first priority") or when recordcount is known within a range, it could be an alternative. Furthermore you can limit the need of memory by using the optional parameters of the GetRows method, such as 100 records at a time: varData = rs.GetRows(1000).

At least a good example for showing another way of populating ReportControl.

Peter

For DoubleClick you can use RowDblClick-Event.

First. Thank you ALL.

After some consideration and tests (even tried with Janus Grid and TGrid) I will stick with CJ report control; always my first choice

My current application will use previous example with Peter59 LoadFromDatabase4 example with getrows(100) option.
193.000 records in 6 seconds.