OpenEuphoria

Re: more help!

• Posted by Irv Mullins <irv at ELLIJAY.COM> Apr 28, 1998
• 599 views

At 07:05 PM 4/28/98 +0000, Luis Campos wrote:

>Hi euphorians!
>    Last night i was taking a look to the simple(not simple for me!)
>    database program included in the Euphoria package( i don't
>    remember it's name right now!). I arrived to the conclusion
>    that it would read the database archive( with estructure of
>    sequence ) stored in the hard disk and put it as a *whole* in
>    ram memory.What would happen if the data base archive is
>   300MB big
>    and i only have 8 MB of ram?(In the documentation says that it
>    doesn't works fine if it has over 1000 records).The creation of
>    swap archive would slow down the speed of
>    reading,finding,etc?
>
It certainly would! Even with lots of memory, with a file this large (or
even a few megs) the speed of loading and saving would be too slow to make a
practical program.

There are two ways I can think of to solve the problem:
 1. Create fixed-length records on disk, then you can do
     reads and writes of single records (using seek, and
     perhaps sorted index files)
  2. Use doubly-linked lists - but this wouldn't be efficient with
      variable length records, either, come to think of it.

Anybody have a better idea?

Irv