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.

 

#2

The attached database seems to be empty.

ObjectDB Support
#3

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

#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
#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
#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?

#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
#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.

Reply