Listbox Memory Question

What are the biggest differences between a listbox and a virtual listbox?   The speed in which information is loaded?  The amount of memory taken up?  Where that memory is located?  I understand how each is created I was just wondering about speed and memory usage comparison.

I realize this is probably a no-brainer, I just thought I would come to the "source of great information" for a quick and highly reliable answer.  :-)

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Wim ten BrinkSelf-employed developerCommented:
Virtual listbox are virtually unlimited in size because they just retrieve the information when you need them. A normal listview demands that you fill it completely with data before it can be shown.
Imagine that you have 100.000 items, but only 30 of them would be visible. A virtual listview would just retrieve the 30 values that it needs to display. A normal listview needs to be filled with all those records first before you can use it. Filling it up costs a lot of time. And of course it would also eat up a lot of memory...

Virtual listviews are especially useful with queries that return a huge amount of data. The data will be stored in the recordset somewhere and the virtual listview will just maneuver through this recordset. A normal listview needs to have a copy of all this data internally before it can start displaying, thus you'd double the amount of required memory. Besides, making that copy consumes a lot of time.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
alexiatAuthor Commented:
Thanks.  Exactly what I wanted to know.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.