> As we know, we tech monkeys tend to have very little time. Could you
> send me a link to th documentation on the in-mem usage in firstsql?

Signature
Lee Fesperman, FFE Software, Inc. (http://www.firstsql.com)
==============================================================
* The Ultimate DBMS is here!
* FirstSQL/J Object/Relational DBMS (http://www.firstsql.com)
based on this very link, FirstSQL/J does not appear to be working
-totally- in-memory, as it is needed in a set up that could not even
have a hard drive
.
FirstSQL/J In-memory Mode
...
Except for increased performance with In-memory mode, the only
difference you will notice is the optional "mode=" startup option and
the creation of the log files and persistent .tab and .ndx files in the
Server/db directory when starting and stopping the database in memory.
.
Processing is as follows:
...
- Any changes to tables (in memory) are logged in a roll forward
journal and written to disk.
- With a controlled shutdown, the engine rewrites all changed tables &
indexes from memory back to disk in FirstSQL/J file format.
...
.
FirstSQL/J is the only commercially available 100% Java IMDB and, as
the first and most sophisticated 100% Java IMDB on the market, it can
be positioned as the leader now and for years to come.
.
I am planning to do some testing of java DBMSs (in-memory and
disk-base ones) and so far I think I will pick H2, HSQLDB, Derby, (very
probably FirstSQL/J,) PostgreSQL and Firebird
.
I hope more DBMS developers would see the benefit of in-mem modes
.
lbrtchx
Lee Fesperman - 23 Nov 2006 09:33 GMT
> based on this very link, FirstSQL/J does not appear to be working
> -totally- in-memory, as it is needed in a set up that could not even
> have a hard drive
That is provided by Flash Mode. The link I gave doesn't provide detail on that mode (I
couldn't tell what you were looking for; the regular docs cover it better.) Flash Mode
is *totally* in-memory, no disk at all. For example, we've run the ORDBMS in Flash Mode
in a unsigned applet (no disk access.)
> I hope more DBMS developers would see the benefit of in-mem modes
> .
The cost of memory continues to drop, and the standard amount of memory on systems
continue to rise, even on mobile devices. 64-bit systems are becoming more prevalent. We
see in-memory databases as a growth area. And, then there are the significant
performance benefits...

Signature
Lee Fesperman, FFE Software, Inc. (http://www.firstsql.com)
==============================================================
* The Ultimate DBMS is here!
* FirstSQL/J Object/Relational DBMS (http://www.firstsql.com)