All this talk about DataBases - but how to select?

[Tiemo Hollmann TB]

Now I have to get into this very interesting thread as a rev novice too.

Storing data is one thing and the possibilities of rev are really perfect.
But how do you get a good performance accesing the however stored datas in a
stack (cards / properties / properties loaded into arrays)?

Saying I want a simple "find all records including / starting with a search
string and some other filters"  a simple "SQL SELECT WHERE" does all the
work for me in a very good performance. Storing the datas in whatever self
made rev structures I have to go with REPEAT LOOPS thru all records, using
perhaps LINEOFFSET() and some IF THEN comparisons. For my experience yet it
is not that performant as SQL with say 10,000 records. But probably I am
still missing some sophisticated indexing technics which I don't see yet.
Anyone willing to share your search / find technology with properties or
arrays?

Thank you

Tiemo