I am currently making a VB6 application to display data from a database. Unfortunately sometimes the users need to see 6000 - 9000 records in one go in a MSHFlexgrid. The amount of time it takes to open this window can be around 10 seconds, although the query itself is not the problem. I really need to use the MSHFlexgrid as other code has been developed around for it.
I have looked around on the web and tried only displaying records that would be visible to the user (with the flexgrids RowIsVisible and TopRow properties) but with no success. Can anyone offer any help with this?
I am currently using the .DataSource = recRecords method.
Thanks for any help.