Problem solve Get help with specific problems with your technologies, process and projects.

Search and filter functionality for preventing information overload

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 last published in November 2005

Dig Deeper on Linux servers



Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.