Database Search

match allmatch any Look in all areasLook in current areas Check all datesPrevious dayPrevious 3 daysPrevious weekPrevious fortnightPrevious monthPrevious 2 monthsPrevious 3 monthsPrevious half-yearPrevious year

TechHome

	Samples from Users
	Sort

• 3-Dimensional Array
• Accessing Multidimensional Arrays
• Add a Row to a Two Dimensional Array
• Array and Lists - Split and Join
• Array copy problem
• Array Size and Making a Binary Copy
• ArrayFileGet VMalloc Error
• ArrayFileGetCsv - How to detect invalid CSV line
• ArrayInsert Examples
• Arrayize and Dimensioned Arrays
• ArrayRedim Issue
• Arrays for the Layman
• Arrays vs Item Lists Speed
• ArraySearch Duplicate Values
• ArrInitialize NULL Fails
• Convert an Array to a Delimited List
• Convert SafeArray into a WIL Array
• Convert String to an Array
• Delete a Member of an Array
• DirInfotoArray Sort
• File Names in the Shell Like Sort Order
• Filling an Array from a column in a DB
• ForEach in Array Trick
• Is it an Array
• Is there an AskArrayList
• ObjectType Error 1690 Ole Unable to Perform Enumeration of the Specified Object
• PtrPersistent and ArrInitialize Issue
• Remove a Line from a File Using Arrays
• Resize an Array
• Reverse Array
• Searching an array for data
• Secondary Sort on Columns
• Sort Files by Modified Date
• Transpose Array
• Variable Table to Array
• VMalloc Error - VirtualAlloc Failed 487
• Why use arrays

Can't find the information you are looking for here? Then leave a message over on our WinBatch Tech Support Forum.

Arrays vs. Item Lists (Speed)

Keywords:   Arrays vs. Item Lists (Speed) 

---

Question:

I have a list of 1000+ LDAP paths that I am working with (contained in a variable). Right now, each individual path is extracted using 'ItemExtract' in a for..next loop. If I converted the list to an Array using 'Arrayize' and pulled the array elements in a for..next loop, would this be faster? In general, are arrays faster than item lists?

Answer:

Ummm. Hmmm. There is not too much "in general" about anything. What the situation is is that many items are optimized for smaller data structures, so for a list of, say, ten items, the ItemExtract is probably better.

However with lots of data, different factors come into play. And thus I think perhaps you could try the Arrayize and use arrays to step thru your data. It may be more efficient in the case you describe.

Here's some code to time code to speed differences:

Decimals(3)
beginetime=GetTickCount()
;all your code goes here
endtime=GetTickCount()

timeinseconds=(endtime-begintime)/1000.0
Message("Time",timeinseconds)

---

Article ID:   W15445

File Created: 2003:05:13:11:27:54

Last Updated: 2003:05:13:11:27:54