The place I'm working for has a need to sort an excel spread sheet the
contains data from bill of materials. The spreadsheets can be up to
60,000 records.

We had a process that did it in a macro but didn't do it correctly.
Another developer wrote a program in VB.net and did a recursive
hieartical sort. This worked fine for small files, but large files it
took over an hour. The sorting is based on different criteia for each
record type in BOM.

Anyone done something similar or have ideas on how to make this work
quicker?

Thanks

Hi Dwight,

I think you are being a little too vague on your problem to get an
effective response. Could you provide a more detailed information of
what you are doing. For instance what are the fields (names, types),
their hierarchy and the respective criteria for ordering (or comparers,
if you have defined some, for instance in the VB program). And what
about the output, is it to be written to excel or can it be written to
a database (access, sqlserver, etc..). Unless you have a remarkably
large number of fields, it should not take more than a few seconds to
do the ordering (this also depends on the ordering algorithm which is
used). It probably takes longer to write back the records... Probably
it would also be useful to take a look at the program you have been
using so far...

-tom

Dwight ha scritto:

Show quoteHide quote

Re: Store multi-choice groupbox selection in a field
Form size ???
Do properties return byref or byval?
select text in textbox
call method on passed form
DataGridView DataBinding
PERFORMANCE QUESTION
.vbprog not installed! VB 2005 - URGENT
Check Mapped Drive is Connected
Serilization of custom object