Q

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

Dig deeper on Linux administration tools

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.

0 comments

Oldest 

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:

-ADS BY GOOGLE

SearchDataCenter

SearchServerVirtualization

SearchCloudComputing

SearchEnterpriseDesktop

Close