Sorting Data

I need help storing some data (temp) for manipulation. The ideal tool is the listbox. But neither it nor the hash table can hold the amount of information required ( < 150 million). I've been using a binary file but I don't think it's a good idea to create so many reads and writes (into the tens of millions) and it's really slow and takes up GBs of space... so this is a big no, no. The same thing would go for SQL.

Does anyone have a solution? I've been thinking about using several hash tables but there might be a easier way instead of constantly checking which hash has the correct value, etc. Any ideas?

Thanks.

[683 byte] By [zdrae] at [2008-1-7]
# 1

What kind of data?

What length of each discreet data entry?

OttoK at 2007-10-2 > top of Msdn Tech,Visual Basic,Visual Basic General...
# 2

OttoK at 2007-10-2 > top of Msdn Tech,Visual Basic,Visual Basic General...
# 3

The data are integers - 12 figures at the most, 6 figures at the very least
zdrae at 2007-10-2 > top of Msdn Tech,Visual Basic,Visual Basic General...
# 4

zdrae,

According to your question, I would like to recommend you to use LsitView control to sort thhe large data. The following article and thread with the example can help you on the issue:

1. Add Flexible Sort Capabilities to ListView Controls

Learn how to make the ListView control sort by a column when a user clicks on a column header, sort by all columns, or sort in just about any other way you can imagine.

2. VB2005 - Listview Column Sort

This sort works on Numeric, Alphanumeric and Data formats. You have to declare the datatype in column headers like so....(Please see the thread)

Hope that can help you on the problem.

BrunoYu-MSFT at 2007-10-2 > top of Msdn Tech,Visual Basic,Visual Basic General...
# 5

Thanks very much. I will take a look at them.

zdrae at 2007-10-2 > top of Msdn Tech,Visual Basic,Visual Basic General...