Hi,
My first impression about InstantDB is that it's storage is very very
ineffective :(
As far as I am making research on pure Java DBMS products I wrote a
simple framework for testing compliance with JDBC/SQL, support for
referential integrity and transactions, performance, storage efficiency,
security and other features. So I tried to store 10000 objects to
InstantDB database. Each of the objects contained 1 long, 2 Strings, 1
int, 1 float, array of
longs with average size of 3 and one serializable Java object that
contained 2 Strings and one more Serializable objects with 7 Strings
inside. I was really supprised that after a long waiting system issued a
message that there is not enough space on disk :) I tried with 100
objects then and it succeeded but lasted couple of seconds (which is
very very long time) and took ~25MB of disk space. I serialized these
100 objects to file and it took just some milliseconds and 18KB :) Well,
database of course should be larger but not more than 1000 times. Even
Hypersonic SQL storing everything in simple plain text scripts took much
less space... I'm getting disappointed with all these freeware and open
source products. I think I better look for some low-cost commertial
products.
DOES ANY ONE KNOW ANY BUYER'S GUIDE OR COMPARISION FOR PURE JAVA DBMS?
--
Darius Silingas
Programmer
No Magic
E-mail: dariuss@nomagiclt.com
Phone: +370 86 12748
WWW: http://www.nomagic.com
-----------------------------------------------------------------------------
To unsubscribe from this mailing list, send email to majordomo@enhydra.org
with the text "unsubscribe instantdb" in the body of the email.
If you have other questions regarding this mailing list, send email to
the list admin at owner-instantdb@enhydra.org.
|