Hi, We are experiencing some big performance problems with Eclipse-CDO/H2 that we can not explain. Our database contains a lot of small rows, that are extensively added/removed and changed. After 5 or 6 hours heavy load on the database, when the database has grown to > 25 GB, we run into a problem that it looks like small changes in the database results in a very long processing time. The database starts to changing hundreds of .log.db files (i.s.o. 1, 2 or 3) for one single update (or select).
Unfortunately we were not able to exactly point to the SQL statement(s) that causes the problem. But we are repeatedly firing the same kind of SQL statements to the database and it looks like if we run into problems when the database exceeds a certain size. Does this sounds familiar to one of you? I will try to investigate further what statement is exactly causing the problem. But if this sounds like a know problem I will be very pleased to hear this. Thanks in advance for your response! Greetings, -- Carel -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To view this discussion on the web visit https://groups.google.com/d/msg/h2-database/-/ywuavBtYwMUJ. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
