indexing flat files

2003-08-14 Thread siva sai
Hi, I have a file (about 3-4 MB ) with about 2 records in it. I need to create an index on a particular field (integer ) in each record. But there might be multiple records matching a particular field value. My queries are something like, "Get all records with the A < field value < B" This

Re: indexing flat files

2003-08-14 Thread Rob Dixon
Hi Siva Siva Sai wrote: > > I have a file (about 3-4 MB ) with about 2 records > in it. I need to create an index on a particular field > (integer) in each record. But there might be multiple > records matching a particular field value. My queries > are something like, > "Get all records with

Re: indexing flat files

2003-08-14 Thread awards
Hi, this is just an Idea and maybe it is the worst idea for what you want. But I 'll go for it :-) What I would do-- I have an Index(sorted) Then the main file with the 20,000 records would be a DBM just a tied or dynamic or a hashed text. using the module SDBM_File, POSIX modules And the index w