Ask the Expert

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.

Requires Free Membership to View

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

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
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
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: