RE: Searching for Data in EDS
- Posted by Matthew Lewis <matthewwalkerlewis at YAHOO.COM> Nov 11, 2002
- 402 views
> From: C. K. Lester [mailto:cklester at yahoo.com] > Let's say I have records set up like this: > > key: X, data: Y > > where X and Y are integers (atoms). > > How would I find all records with Y = 2? > > Do I just have to loop through all the records? What if I > have a million > records?! > > Elsewhere, anybody already have good code for managing EDS > files to handle > cases like this (a function that returns a sequence with the > record numbers > of all records where Y = 2)...? Your best bet is to use indices (there was a fairly in depth treatment on this topic previously--I believe the question was regarding record albums, and I think Irv was the main responder), where you keep a separate table/record to remember all the keys which have certain properties. I'm working on a lib (slowly and inconsistently :) to make EDS into a SQL db, and have some limited support for indices currently, but without some sort of index, you'll need to loop through all records. Matt Lewis