ObjectDB ObjectDB

Issue #2601: Table view freezes the program

Type: Bug ReoprtPriority: NormalStatus: FixedReplies: 7
#1

This shows pressing an Entity and pressing Table view freezes the program, this is a remote DB not on local machine.  But it should not be this slow with 10 records.  The query is not slow, but if yo just open table view like in the video it's slow/freezes.

 

edit
delete
#2

The attached database seems to be empty.

ObjectDB Support
ObjectDB - Fast Object Database for Java (JPA/JDO)
edit
delete
#3

Here is another.  Doesn't matter what data, it behaves the same as the video, I removed the video for privacy reasons.

edit
delete
#4

It seems challenging to repeat this issue: the table is opened quickly in both embedded mode and client-server mode. Please check and advise.

ObjectDB Support
ObjectDB - Fast Object Database for Java (JPA/JDO)
edit
delete
#5

Build 2.8.3_05 introduces a new setting:
  "Use Queries for Viewing all Class Instances" in Options > General.

When enabled, opening tree/table views from the schema tab uses queries, which don't have that problem. The default (in previous version and when this setting is unchecked) is a different method, which is usually expected to be more efficient (loading data more lazily), but apparently it is less efficient with slow client-server connections, due to more round trips.

ObjectDB Support
ObjectDB - Fast Object Database for Java (JPA/JDO)
edit
delete
#6

I tried unchecking and checking, they both perform fine now though.  So I'm not sure if it's due to query or not?

edit
delete
#7

Actually there is also an improvement to the non-query implementation in this build, so apparently it solves the issue without switching to queries.

ObjectDB Support
ObjectDB - Fast Object Database for Java (JPA/JDO)
edit
delete
#8

OK that makes sense.  I checked again, non-query method on a big table, is in fact slightly slower than query method.  But yah definitely not freezing like before.

edit
delete

Reply

To post on this website please sign in.