What is considerd the most efficient method of sorting an array?

EG:
1..Re ordering the values from lowest to highest - or visa versa
2..Detecting duplicates
etc...

I dont believe there are specific VBscript functions and have found conflicting opinions in my research. Some even suggest flirting with javascript's .sort


Wind is your friend
Matt

__________________
Wind is your friend
Matt

Hi Matt,

You might want to take a look at this?

How can I quickly sort a VBScript array?

How can I sort a VB Script array in ways other than by case-sensitive alphanumeric order, like numeric value, length of string, or even randomly?

Hope that helps.
Cheers!

_________________________
-Vijay G
Strive for Perfection

Vijay

Thank you for your time, a couple of good links.

Wind is your friend
Matt

Looking for thoughts/opinions:

-------------quote-------------
You could simply write your own sort algorithm (like a bubble sort) and encapsulate it in a function, however there's another way that's faster, while remaining very flexible. The key is using the JScript array's highly efficient sort method
--------------finish quote-----
Ref:http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=83
------------------------------

My two cents worth:
I dont question the above information, wouldnt dare....
However, I find it a bit weird skipping between jScript and vbScript could be the most efficient method of array sorting. Does anybody have the time to explain how this could be?

My objective:
I have a project that requires an audit tool, I am convinced - extracting info from DB (very possible large amounts of data) populating array(s) then sorting is the most resource efficient method. While sorting I will be checking/refining existing arrrays, creating new arrays etc....

Summary:
This brings me back to my intial question (start of this post)
"What is considerd the most efficient method of sorting an array?"
Should I use this vbScript/jsScript method?
OR
Go with my usual multiple nested FOR loops?

Thank you in advance


Wind is your friend
Matt

Hi Matt,

Just widened my search on array sorting, seeing your concerns based on efficiency hit with skipping between JScript and VBScript. Found this URL that uses either VBScript or Javascript, whichever you feel that suits your requirement, you can stick to that.

Sorting Arrays: VBScript Implementation

Sorting Two Dimensional Arrays: VBScript Implementation

Randomly Reordering an Array - got three parts and live demo too.

PS: I actually had that in my favourites, didn't strike at the right time. Have used this in my system sometime back, and works fine.

Hope that answers you requirement.
Cheers!

_________________________
-Vijay G
Strive for Perfection