What VB6 control do you recommend for displaying more than 10,000 rows of data after executing a querry?
I came up with this question because you stated in one of your examples that "Note: Listviews are not very efficient with memory." I agree with your statement but I would just like to know what could be the best possible method to use for the job when displaying huge amounts of data.
Regardless of the language or interface, displaying 10,000 or more rows of data to the user is rarely a good idea. Showing all those rows rarely accomplishes more than providing the user with information overload.
Rather than showing the user so many rows, look at providing the user with search and filter functionality. When the rows matched exceed a reasonable (and possibly user-configurable) number, paginate the rows so the user (and your application) can deal with the data in more manageable chunks.
Look into the LIMIT clause as a tool to help break up a result set to make it more manageable.
This was first published in November 2005