Search and filter functionality for preventing information overload

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

    Login

    When you register, my team of editors will also send you resources covering Linux administration and management; integration and interoperability between Linux, Windows and Unix; securing Linux and mixed-platform environments; and migrating to Linux.

    Margie Semilof, Editorial Director

    By submitting your registration information to SearchEnterpriseLinux.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchEnterpriseLinux.com is governed by our Terms of Use. You may contact us at webmaster@TechTarget.com.

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

Back to top