ObjectDB Database Search

Hello, we have a question again regarding query performance . The query: SELECT v FROM Values v ... ; @OneToOne (fetch = FetchType.EAGER) private TCStep step; //For performance reasons, we use a list ... are always slower because multiple entities are involved. You can improve the performance of queries by using

Care Centres across Sri Lanka. We've recently migrated to ObjectDB to improve performance . Despite the migration, we're experiencing general performance issues across all transactions. As requested in ... ObjectDB. You can achieve much better performance by applying minor modifications to the object model

Hi, we have a strange performance problem with ObjectDB 2.5.3_01 and JBoss 7.1.1 ... separate test environment its speed is very good. We did a performance analysis on our 2 linux ... . We pinpointed that from he 53 record performances degrades significantly. On other queries threshold

implements LocalEntity Please create a separate thread regarding the persisting performance and provide ... will post another thread for the performance issue regards! paddy Patrick Gerhardt

Hello, we can't understand why the performance of queries is not the best and the execution requires so much memory. In the implementation of our UnitTests we have used "DELETE FROM Object" to delete the database. That did not work because we often get an "out of memory" exception

, it is supposed that the count of every field should be the same performance . I have no time to test

Hello, we have a performance problem when we use a large transaction. Let's do exactly the same in several transactions the ObjectDB works much faster. In our use case, we create many new entities and between the creations we call a select query. The execution of the query becomes slower at each

Performance issues on aggregate query

Low performance when getting grove roots

Performance of "InsertTest"

Help: After upgrading from 2.2.8_02 to 2.2.8_04, can't perform LIKE query

can improve performance by reducing file fragmentation that can result from frequent resize operations ... , the recovery file can be used to repair it. ObjectDB automatically performs recovery when it opens ... file on separate storage devices, such as different disks, can improve performance . The max attribute

performance and can sometimes reduce the amount of Java code needed. Note that query results ... results might affect performance , depending on the size of the query result list and other factors. SELECT

); Flushing changes to the database before every query execution can significantly affect performance . Therefore, you should consider this issue when performance is important. Lock mode (setLockMode

Works of, publicly display, publicly perform , sublicense, and distribute the Work and such Derivative

, using property access can have performance benefits. This isn't the case with ObjectDB

performance problems. For example, consider the following query execution and result iteration

to perform optimistic locking checks. Enum mapping Configure how Java enumerated types are persisted and used

matches the field order in the WHERE clause, ObjectDB can perform a more efficient range scan

to perform operations that affect the state of the persistence context, or that modify the lifecycle state ... , the persistence provider must perform optimistic version checks when obtaining the database lock ... mode type is pessimistic and the entity has a version attribute, the persistence provider must perform

of one class in different 'tables'. Please clarify: Is it only for improving performance , or do you also expect a change in functionality? How exactly performance should be improved if the  ... 'tables'. - Yes Is it only for improving performance , or do you also expect a change in functionality

is done via JTA, or it may be a resource-local entity manager, where transaction management is performed

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder CriteriaUpdate createCriteriaUpdate (    Class targetEntity ) Create a CriteriaUpdate query object to perform a bulk update operation. Parameters: targetEntity - target type for update operation Returns: the query object. Since: Jakarta Persistence (JPA) 2.1

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder CriteriaDelete createCriteriaDelete (    Class targetEntity ) Create a CriteriaDelete query object to perform a bulk delete operation. Parameters: targetEntity - target type for delete operation Returns: the query object. Since: Jakarta Persistence (JPA) 2.1

class enhancing has indeed been performed .   I have this at the entry to my application: public ... ("ObjectDB class enhancing HAS been " + " performed ."); else System.out.format("ERROR! ObjectDB class enhancing has NOT been performed ."); // todo end ... I get the following output when I run

), there is a massive drop in performance . We have already seen that queries take more than 20 seconds ... of this? We are not aware of this issue (no previous reports). A drop in performance from a few milliseconds ... the entire database but the virtualization space is limited then obviously this can cause a performance

which rewriting from scratch might be faster. You may also consider improving performance by: Using ... (and if you can use one transaction for deletion of many updates it can also improve performance ... FYI, a new ObjectDB 2 version that has just been released (2.0 RC3) improves performance of insert

); } } GuestServlet performs the following operations on every http request: The EntityManagerFactory

The Guest entities will be stored in an ObjectDB database, which will be represented by a JPA's EntityManagerFactory instance with a global application scope. We have to register a ServletContextListener to perform initialization and cleanup operations: The database will be opened (or created

(disk)? Can setting sync=true (for recovery) help with this issue, how will be the performance ... , but you may lose some operations that have been performed after that point. Enabling sync reduces the risk of data loss significantly at the possible cost of performance (the exact effect depends

performance hit. Problem 2: executing a query that returns User with id 5,6,7 (or any other) takes fresh data ... Chirac The purpose of the L2 cache is to improve performance mainly by minimizing client server round ... without performance penalty. You can change this behavior by setting the  "objectdb.result-fetch" query hint

of the performance problem. The ObjectDB cluster may be a distributed database, I guess. But I dont know ... does) to support larger databases, but that will come with a price tag of slower performance . In ... is on the slave side only. support Support but that will come with a price tag of slower performance . 

?  The online backup feature appears to copy the dead space as well so isn't performing ... We are trying to optimize the database size due to the time it takes to perform an online backup ... window of time to perform these backups.  We've looked into using the replication strategy

Hi, We are trying to create a servlet that performs database online backup. Unfortunately, even though no exception is thrown, backup files aren't created. When I turn on DEBUG logging in ODB, I ... home directory on db server.   I also tried to perform backup from standalone application

becomes more complex. Such changes must be performed with great care. When ObjectDB starts after the refactoring ... operations that were performed would help us better understand and diagnose the issue. support Support

side). Regarding performance , it may improve performance of adding / removing readers, but traversal from

Support Do I have to make this change on the server? How does this affect performance ... performance a bit or may not, but if it eliminates the issue it will help for diagnosis. It is definitely

was modified with: But after few benchmarks I don't really see any difference in performance . ODB ... and then check if it is cached. The L2 cache doesn't always improve performance . It depends on the application

fixed an issue with queries ( issue #2858 ) but had a known query performance regression. It was fixed in version 2.8.9_02 but maybe there is another relevant query performance regression

) 3) use jdo from jpa - is there a performance penalty for unwrapping PersistenceManager.class ... David Moshal 3) use jdo from jpa - is there a performance penalty for unwrapping PersistenceManager

of one writer and multiple readers provides better performance because the coordination between the servers ... including better performance , full ACID, richer queries and rapid development. support Support

to the odb file in order to improve the performance . As long as the data is written to the recovery ... ; , but is is expected to decrease the performance . The  .odr files are related to the recording

it: As the embedded DB seems to be with superior performance would you recommend using it with TomEE ... mode is faster, so embedding ObjectDB in the main Tomcat server will improve performance

) and it also leads to performance penalty. support Support Thank you for your fast reply. I really meant ... in queries lead to performance penalty, how slow is it and would you recommend something better

, how to test the real performance of objectdb? The structure of my class is ::=( , , , , ), why "any ... gzdillon Lai Yang Sure. You should test the performance of ObjectDB with real data

I have an application that I have been converting from JPA/MySQL to JDO/ObjectDB and I have hit a problem with indexing. An index on a String field is required to give good performance but if I add ... versions, as we have had positive experiences of the performances of object databases and JDO

Hi, I have a 12GB database with 787603 entries. It is much larger than usual and there are performances issues. I am doing small queries and they take much longer than I expect, i.e.: Get the total ... and the performances are much better. I will try composite index later. However there is one thing I haven't

performance after the configuration change and report as it may have significant effect on speed in ... of recovery failure with lower performance hit. support Support ok hgzwicker Hans-Georg Zwicker our performance monitoring shows that creating of object structures is significantly slower than with the old

indicating deep query plan checks and an overall significant performance loss in all queries ... . Decreasing the number of query plans can solve the performance issue in this specific case ... it would be useful (although that change improves performance in other cases). What is the purpose of updating

; Perhaps there is some performance tradoff with this update to save memory usage? In the attached ... this update) and see if there's a performance difference. Trianglehead Json Error Just an update