Development Team Blog

In [URL="http://support.dataaccess.com/forums/blog.php?b=48"]Part One[/URL] I described the problem of performing lookups for each member of an array and how to use a cache when performing lookups repeatedly with multiple arrays sharing mostly the same members.

We left part one after describing a caching technique that required further optimization. In this article we will explore different array searching techniques, using the built-in VDF Search Array functions, to optimize ...

Attached Files

• Cached Lookups.zip (805.1 KB, 1310 views)

A common programming problem is the need to process sets of data that are not part of your database. Typically sets of data that are stored in arrays. If the data is structured then you would use arrays of type [I]struct[/I]. For example...

[code]Struct tNameData
String sName
Date dDateOfBirth
End_Struct

tNameData[] NameData // declares an array of type tNameData
[/code]Wherever you have arrays of data like this you will inevitably need ...

Attached Thumbnails