OpenEuphoria

Re: aboutDBE

• Posted by Robert Craig <rds at RapidEuphoria.com> Nov 25, 2001
• 354 views

Sergio Gelli writes:
> Ok the programs do it, however it delays more 
> than 300 seconds. It's so bad. A Data Base
> don't can works like so, taking a long time.
>
> Okay. My ultmov.txt has about 25.000 lines, but
> another DataBases can do it in less than one
> second.
>
> So, what i do wrong ?? 

I changed createdb.ex on my machine to insert 25,000
records. It took 101 seconds. So you are probably
not doing anything wrong. 

It's slow because it's set up to insert one record at a time. 
It reads and writes information to the disk each time.
If I wrote a routine to insert many records at once, 
it would be much faster, but I think a typical application
would have a user interface where a user types information,
clicks OK, and the program does one db_insert(). 
Even on your machine, 300 seconds / 25000 =  12 milliseconds 
per insert. The user isn't going to notice the time, and more common
things like lookups will be much faster than this.
I imagine you will only do 25000 inserts when you first create the
database, not every day.

Regards,
   Rob Craig
   Rapid Deployment Software
   http://www.RapidEuphoria.com