ObjectDB Database Search

, however there are quite a few "spikes" in the performance where we are getting a lot of very slow ... in some cases and is slow in others. Also, the slow response times occur in wide variety ... the database file is resized approximately every hour. Each time at the same time we see these slow

), but it seems to be very slow . The database is quite empty now, just between 5-20 records / entity, but it's still very very slow . That's the only thing that is slow on my server... How can I speed it up? zmirc Mircea Chirac It's sooooo slow . It takes ages to open an entity or to refresh data. zmirc Mircea Chirac

are scanned to get candidates for querying the primary key.  This is the slow part.   I'm looking ... The second query is slow because of the need to retrieve timeReceived value for a lot of objects

Hi, I have found a strange behavior when merging entities with "mapped by" set on @OneToMany relation. Even if object is fetched with find on the same transaction, merge is very slow . It's because on merge every single relation marked as LAZY is fetch from database. Attached two examples

it up?       Stefan Stefan Mair Your test becomes slow as the database is filled

- This code is tested on Windows and Mac. Windows is working great, Mac is very slow (read is 11 seconds on Mac, and 100 milliseconds on Windows). - Application is using Spring Boot console application (for JPA implementation) - MacOS Sierra 10.12.3, Core i7 CPU, 16GB RAM, SSD drive java version

* * EntityManager.find(entityClass, primaryKey) is slow when accessing * non-existent IDs. * * Select queries

slow performance for a complex query

Queries are slow on a large database

Mapped By Fetch is very Slow

Slow loading from db

Slow performace in virtual machine

requires slow conversions between graphs of Java objects and flat database table rows. Object Relational

when the database is opened. Preparation of the initial backup might be slow if the database is large

. But even with an index, executing a query for loading a field is relatively slow . Therefore, if the employees

Out of Memory - Slow leak?

so wrong that virtualization from the market leader VMware slows everything down so much? Priiiiil ... the hardware. If you can publish diagnosis info of the slow activity it might help. support Support Thank ... OutOfMemoryError , so maybe it is just slow because the heap size is large. Given that the database

milliseconds. Adding a new left join on remaining 8 slows down query execution time drastically. Please help ... to be  slow , but if you can post a simple minimal runnable test case (see  posting instructions ) that demonstrates the slow query, then we can check it. support Support Hi,  I've attached

. If there are still issues with the website, please report. Thanks!   support Support It is still very slow ... even load at all. Sometimes it happens to load fast, but most of the time it's slow or very slow . Buy proper ... , and when this is ready operations that are slow now (such as searching and posting) are expected

... still seems slow . Thanks EKK import java.io.Serializable; import javax.persistence.Entity; @Entity public class ... call is working blazing fast (100ms). On Mac is very very slow (3sec). duskov Dusko Vuksanovic Are you sure that this is the same issue of a slow query that returns many objects? In that case, the same

that the specific slow operation (possibly a complex query) is slow also for a single user? i.e. can you check if the performance issue is due to load of several concurrent clients, or maybe same slow performance ... , but the later is usually more complex and sometimes limited. If you find that a particular query is slow

); query.setParameter("pclass", partyClass); We have noticed that this query slows down in a linear way ... (otherParty and relationshipType) but subclassName is not indexed, would that be the cause for the slow query ... the relationshipType index back and started a test with an empty database. It slowed down significantly

Hi, I have observed that 500 Mb objectDb database opening time is very slow (~3 seconds ... thread:Thread-6): doOpenDataStore(): openDataStore: D:\odb\files\anritsu\T1792 Slow Open.odb.pa3 1/23 ... \T1792 Slow Open.odb.pa3 1/23/2016 15:42:48.4248: INFO : (AppDataStoreManager.java:257 thread:Thread

. But exporting large binary data sets is very slow . To avoid memory problems the binary data type is read step ... data sets the way is slow . We have an own entity for storing binary data (pictures, documents). Hint

of objects should take only milliseconds. There could be several reasons for slow query execution, including ... result loading. Loading the query results could be very slow if eager fetch is used extensively

://zeroturnaround.com/rebellabs/how-to-use-jpa-correctly-to-avoid-complaints-of-a- slow -application/ In ... , but may also consume too much RAM and becomes slow . Unfortunately there is no one best solution for every situation

the objects (around 5s) and I think I do something wrong because it's so slow . (DB has around 30.000 rows ... no difference. edit2: persisting values is also very slow (5-6s for 30.000 inserts). Environment

method does a lot of work so it is expected to be relatively slow . Usually this is not an issue ... ). support Support Thanks for your quick response, it solves the issue of slowness . vinothr120 Vinoth Ramesh

to do and why they are so slow , when this happens. For this CPU and thread profiling, e.g. from VisualVM ... another createEntityManager immediately when it happens, will it also be slow ? Maybe it could be useful to check

, is very slow . Is any or all the databases that you made available can demonstrate the slow query

in queries lead to performance penalty, how slow is it and would you recommend something better

that the 1:10 ratio is only for relatively small databases. It is true, however, that it is slow

this. About the slow lazy loading - a test case that demonstrates it is needed to evaluate this. support Support

hi, my current use case is: execute unit test, verify results in explorer. my problem, i have to close the explorer before every run, and open it again after the tests are done. this slows down the whole process. i opened the database in readonly mode, but the file will be locked by the explorer

. Sometimes enabling the L2 cache may slow the application because of the overhead in keeping

model. It might be a slow query. Maybe indexes on the relevant fields of B could help. support

slow - that is expected, because of some high number of objects to download. I forget to mention in

- and that is slow if you have millions of objects. Currently the workaround is to use queries

.setFirstResult(start).setMaxResults(count).getResultList(); is quite slow . Well, after first request and "warming

that it is indeed very slow . Could you please provide a typical value for the ?1 (end date) parameter ... slow as using this composite index doesn't solve the problem, so further work is needed. Will keep you informed. support Support As discussed above, the reason that this query is very slow is not

that are not related to query execution timeout and if there are side effects such as slowness ... seconds timeout set. At the times when the timeout happens the system is very slow hgzpincher Hans ... info that should be removed). Obviously queries that need more than 100 seconds slow

when the slow removal happens? It may help to identify the exact build in which this issue is started. 2 ... -Georg Zwicker Do you know how to reproduce the slow removal problem using this database? You wrote ... addition to this slow behaviour we have several times a day the situation that a normal select

may be: Filter repeating requests / queries. Try to optimise queries that are too slow (and a few seconds could also be considered by users as slow ), e.g. by using additional indexes, to prevent ... if the response is too slow (again and again, as most of us do), and then a small delay produces

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.   Trianglehead Json Error ... with slow client-server connections, due to more round trips. support Support I tried unchecking

. felixobjectdb Richard Szurgot Actually, this may just be slow performance rather than blocking ... be appreciated. felixobjectdb Richard Szurgot Extremely slow performance may be the result of using zero size

setting, it is more or less not acceptable to slow down the system like this hgzwicker Hans-Georg Zwicker File sync is a slow operation so this is expected. Although we cannot improve the speed

. If you need help with selecting query plan hints to optimise other slow query plans we can help ... on a better solution proceeds. If you can provide several different queries (that are known to be slow

Added an option to slow backup (see  feature request #2681 ). Added an option to view old type versions in the Explorer (-Dobjectdb.ui.debug=true) Improved the Doctor (see  issue #2691 ... to slow backup in client-server mode (see  feature request #2681 ). Fixed Explorer issue after schema

ObjectDB supports encryption of client-server communication over the network using SSL . Encryption of data in database files is less commonly used, since it slows the database. In addition, when necessary, external encryption can be used (e.g. at the operating system level

; This caused the ID lookups on non-existent entities to be " slow " due to an internal exception (thrown