Hi,
same problem here.
After upgrade h2-1.3.174.jar to h2-1.3.176.jar and connect to my exist db
file I get to following trace: (without any executed statement, just
connect)
04-10 11:50:39 database: ALTER TABLE PUBLIC.REL_USERS_RIGHTS ADD CONSTRAINT
PUBLIC.REL_USERS_RIGHTS_FK_ID_USER FOREIGN
Thank you very much, Thomas, your hint on LSM-trees opened my eyes!
(a little smalltalk: sometimes I tend to forget that there are laws of
nature in computer science too... naive thought: That doesn't fit into
memory, so lets store it in a database, DBs are so smart these days, they
will give
Thomas, perhaps we need a way of adding sorted entries to MVStore that is
optimized to reduce writes and reduce internal page node splitting?
Kind of like INSERT SORTED.
--
You received this message because you are subscribed to the Google Groups H2
Database group.
To unsubscribe from
Hi,
Thomas, perhaps we need a way of adding sorted entries to MVStore that is
optimized to reduce writes and reduce internal page node splitting?
Well, inserting entries in sorted order shouldn't be all that slow. Is it?
What is quite slow is adding entries in random order. I ran into this