Is there a way to query a VB Script Array?

I'd like to be able to query an array 开发者_如何学Go(multi and single dimensional ) with something like SQL. Is there a way to do this?

It just seems extraordinarily wasteful to step through it one record at a time.

Nope. Do you wasteful in terms of having to write the loop, or performance wise? I'd expect heaping a layer of abstraction over the array would hinder performance.

If you need to search your arrays in something other than linear time (ie., one at a time), you'll need to organize them so that you can so a binary search over them (or any number of other algorithms).

A disconnected recordset might suit: How do I sort arrays using vbscript?