ObjectDB Database Search

total) 02_firstdb closed connection (File-Close connection) 22 sockets open 03_firstdb open second ... created during socket creation. Those are created with 2 seconds interval ... and nothing prevents the JVM from removing them. Actually it seems that during these 4-5 seconds the JVM

, with object 1.x, the same query was getting executed within an seconds and now the same is taking around 40 seconds in object db 2.x I have build the query using the follwoing Query query = persistanceManager ... query.execute(param1, param2); This takes 1 second to execute using objectdb1.x, but the same takes

1. I got about 10K inserts / second , is it normal? I would expect more than that, like close to 100K/ second . I can definitely do 80K inserts/ seconds on Oracle with batch insert on table ... Device instances per second . But Device is a large object with an array of 100 strings (by the way

: listPatientsByIDsWithBasicData Duration: Takes around 3 seconds to search   Search Method public List ... of Health Sri Lanka You should be able to get the results in milliseconds rather than 3 seconds ... to get the results in milliseconds rather than 3 seconds " was that the execution time should be much faster

), there is a massive drop in performance. We have already seen that queries take more than 20 seconds ... to up to 20 seconds is extreme and requires further investigation. Your suggestion that partial ... gigabytes per second . So actually an absolute overkill for the 7 employees on the Windows Terminal

. In our web application this behaviour gives aprox 10-13 s of refreshing a data table vs 2 second ... from JBoss. • Result - 3 seconds for 50 to 1000 results (this is from JBOSS Vaadin application The production database on the production server from JBoss • Result - 13 seconds for 50 to 1000 results

: 8,5 seconds against 30 seconds with hibernate+mysql. Then I started the test again and got 9,5 seconds ; then 11 seconds and so on. Should I change my config in some way to get more stable insertion time ... and everything worked like a charm: the execution time of test now is around 2 seconds . Thanks for assistance. 4410 Arsenii

an additional data point I'm experiencing a 15 or so second delay here in Canada where  a second ... times I have up to 15 seconds waiting time for a request to complete. Sometimes it doesn't ... Canada too - one or two second response time. Thank you ObjectDB for your quick fix

. SQLite in comparison responds within few seconds on average with the same number of records. We hope ... of 5 records per second . Each add is a single new object and is wrapped in a transaction. 2. The 2nd ... for about 60 seconds . By this time a number of new records are already being added by

around 500 ms, sometimes it takes 20 seconds   select distinct o from ObjectNode o join o ... takes around 500 ms, sometimes it takes 20 seconds Can you confirm that the provided databases demonstrate the ~20 seconds in a consistent way? It is just not clear from post #1. support Support

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Predicate lt (    Expression x ,    Expression y ) Create a predicate for testing whether the first argument is less than the second . Parameters: x - expression y - expression Returns: less-than predicate. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Predicate lt (    Expression x ,    Number y ) Create a predicate for testing whether the first argument is less than the second . Parameters: x - expression y - value Returns: less-than predicate. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Predicate le (    Expression x ,    Expression y ) Create a predicate for testing whether the first argument is less than or equal to the second . Parameters: x - expression y - expression Returns

,HOUR_OF_DAY=19,MINUTE=14, SECOND =43,MILLISECOND=31,ZONE_OFFSET=0,DST_OFFSET=3600000], java.util ... ,DAY_OF_WEEK=2,DAY_OF_WEEK_IN_MONTH=5,AM_PM=1,HOUR=7,HOUR_OF_DAY=19,MINUTE=14, SECOND =43,MILLISECOND ... _OF_YEAR=150,DAY_OF_WEEK=2,DAY_OF_WEEK_IN_MONTH=5,AM_PM=1,HOUR=7,HOUR_OF_DAY=19,MINUTE=14, SECOND =43

and then doCancelEdit works fine. Second time I doEdit produces the error "Attempt to lock a non entity ... ;    System.out.println("After second lock before update: " + p.name);   ... ; System.out.println("After update before second rollback: " + p.name);     

Hi, I have observed that 500 Mb objectDb database opening time is very slow (~3 seconds ... of a second to open a database of any size. Please provide more details. If you can make this specific ... to understand what activity is done during these 3 seconds . support Support I will prepare test application

null is returned. I have tried to clear the entity manager in the second call to make sure the reading ... the entity manager in the second call to make sure the reading will be done from the DB but no success ... , when I check the document instance in the second call, the collection of readings is null but the rest

at any one time. The load never exceeds more than 5 transactions per 10 seconds .   So far we know ... seconds . All other functions of the system continued as usual, however the DB started reporting ... ;      calendar.set(Calendar. SECOND , 0);       

take no more than 1-2 seconds to complete, then setting an expiration time of 5 seconds should be safe ... , could the lock be released say 5 or 10 seconds after the connection has broken.   As a side note, I

(and enhancement) it persists 340,000 objects per second ". Insertion Speed Rate and Batch Load Now, ten years later, I run it on Intel Core i5-5300U (2.3Ghz) with 8GB memory, output is 45000 per second ... ? After the augment of em.clear(), output changes to 301000 per second . It still below your original InsertTest

, because sometimes it doesn't work, but you don't know. It's the second time when I encounter this bug in 2 ... can be found, so I don't have to modify this second project, because this is much larger ... , without needing to redeploy/run the app the second time (after the wrong numbers are printed

the second junit test, you will see heaps of calls like: AttributeName EQUALS method called ... only at the database id.   Second issue. The docs at: http://www.objectdb.com/api/java/jpa/OneToMany state ... if you describe your expectations more clearly. In the second problem - do you expect disabling cascading through keys

is enabled. support Support L2 cache? I'm not sure. But why the second find() will output? By the way, a query "select e from nodes e" will be ok regardless of the first time or the second time ... I'm doubting the example in jpab.jar runs twice in each test and choose only the second result, maybe

a parameter argument for the second outer query. support Support You may try splitting the query ... argument for the second outer query. Your suggestion is not feasible. I want to get a list of extinct ... the result collection as a parameter argument for the second outer query. gzdillon Lai Yang The inner query

.objectdb.Doctor.main(Doctor.java:22) [ObjectDB 2.1.1_04] Java heap space and second try: odb@devodb ... well with the default configuration - it took ~10 seconds to check the database and additional 20 seconds to rebuild a new database. With 256MB max heap size I got the same  OutOfMemoryError

everything is ok. Afterwards i added the replication tag to the configuration of the second server and started it. The second server starts complaining instantly with the following Exception: com.objectdb ... .Thread.run(Thread.java:722) This message is repeated every few seconds . I already tried to fix

it at '0' all the way to '10000' (10 seconds ) I can't accomplish this. The ideal case ... ; I used  5 seconds (5000 milliseconds) and I never saw the issue again. I assume you are using

Hi, I make a full binary tree of 4095 node, I check the first 9 node, but the root cost 24 seconds , why? Result: =========== find time @ 24.125000 getSons time @ 0.000000 1 : type:Nodes, sons:2 ... = (System.currentTimeMillis()-start)/1000f;   System.out.printf("Insert: %f objects per second %n", iNum

; Everything works fine when running with one thread, however, when adding a second thread some ... objects and then the second query for the organisations returns 800 objects as expected.   eitane

/ setters ... } when I query by the "state" field in TestEntity it tooks several seconds to retrieve ... the second entity completely and integrate its 3 variables directly in the TestEntity... but it makes

(); c1.increase(); // Second user retrieves and updates the Counter:   PersistenceManager pm2 ... ().commit(); pm1.close(); // Second user commits - fails with JDOOptimisticVerificationException

.MINUTE, 0);         cal.set(Calendar. SECOND , 0);    ... ;       cal.set(Calendar. SECOND , 0);       

a few seconds after it becomes accessible again. Inactivity Timeout You can set the inactivity timeout  in seconds and it affects both the client and the server side:       

I have a call to getObjectsById(Collection,boolean) that is throwing a JDOException the first time I'm attempting to retrieve an object. If I try again, then the second request succeeds. Any idea ... getting. Your advice to ignore them explains why it would work the second time around.  I believe

In our production environment, entity manager creation, the line below, sometimes take upto few ten's of seconds to create. Is there any reason that is known which may be causing this ? Any ... seconds to return. CAPdev CAP Dev Is it client-server mode or embedded mode? If client-server mode

Hello, I have a problem with the following situation. I insert persons with addresses. In the first run, they are all new with a new address. It runs fast. In the second run, the persons are all loaded and got a second address. This seams to be much slower. The Entities are all enhanced by

, DAY , HOUR , MINUTE , SECOND ) was just added to ObjectDB in build 2.2.8_02. For example ... ;     "HOUR(e.t), MINUTE(e.t), SECOND (e.t) FROM MyEntity e",    

collections in the first pack of queries and non-zero size results in the second pack ? I ... , minutes, seconds , and milliseconds are 0, but relative to UTC. Therefore, the parameter to the query

({t '23:59:00'}) is evaluated to 59. SECOND ({t '23:59:00'}) is evaluated to 0. Quite often I ... ) - Extracts the time part (hour, minute, second , millisecond) as a Date instance. Please try

queries increased with this database size to an unacceptable rate (several seconds compared ... for query like this (400000 ObjectNode instances, database size around 1.5 GByte): around 1.5 seconds

(0x00000000b6681e10) by one thread. The second thread dump (0x00000000bc88c318) is related ... to time that a query that normally takes a second does take minutes hgzwicker Hans-Georg Zwicker The first ... (and a few seconds could also be considered by users as slow), e.g. by using additional indexes, to prevent

seconds ? In this case an exception is expected, but the log lines should be improved, as reader ... 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

" is missing at the end of the query. Please check the query. Second , if there is an internal ... and you will see no problems with this query Second , I have attached a) Screenshot for used ObjectDb version b) Original

seconds . Could you please check running that query in the Explorer? support Support Execution time ... -var-order=p1]] execution time around 60 seconds Query plan 1/16 description

which is correct, the second query also returns 1 result but 0 tags which is obviously wrong ... , for the second query 1 year in the past. Otherwise there would be no bug. My provided test case

the second query. Do I need to call refresh() on the object, query, or EntityManager? ps: setting ... at all, I was expecting that the object would be returned in the second query. That doesn't happen

use a second database. Within the real transaction we work with a copy of this database. This enables us to repeatedly commit on the second database and in case of a fault we can still recover

) or (p1.name = "startableState" and p1.doubleValue = 0)) 2.7.6 takes around 4 seconds 2.7.6_04 takes 200 seconds and reports in query plan:   Query plan 1/2 description

and have activated the license.  My application is persisting about 1000 of these each second from among 500 active threads.  Between each persist, the thread sleeps for half a second . 

and prepare final results. Second query (which fails): Query Plan Description ... results. quasado Alexander Adam By the way, the second query also has way too many executions in