Re: Indexing and Data Files
On Mon, 27 Dec 1999, you wrote:
> I know this has been asked MANY times before, but I can't seem to
> keep up with the answers I printed out. So, I'll ask it once more.
>
> I am working on several projects that need database handling. My
> question is this: Has anyone developed a library or set of routines for
> file handling in a database, or do I need to write my own routines.
That's all I have been doing lately - database handling. I haven't found
a library that helps.
First thing, however, is to consider whether or not you can fit
all your data into memory. If so, then the Euphoria routines to
search and sort, etc. are fairly trivial, and performance is excellent. You
can fit a lot of data into 32 or 64 megs, you know. I'll be glad to share the
code I have.
If your data files are going to be larger, then there's little choice but to
design with fixed-length fields and block read/write functions.
Indexing isn't difficult to implement, but maintaining the indexes thru
deletions, insertions, and modifications may be a bigger task than you are
willing to take on. Unless your data files are HUGE, it's easier to just
re-index each time you make a change.
Regards,
Irv
|
Not Categorized, Please Help
|
|
