About SECOND

forum_thread

Queries are slow on a large database

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 number of entries Get 25 consecutive entries (i.e. 0-25) Get one specific entry On average each query needs 4 to 5 minutes to return a result. I have been adviced to use indexes but they are already used through the JDO Metadata file. For instance I use this class: ... which the first component is  logTestRunId and the second is Id can be the solution for this specific query, because results ...

 
issue

Threaded Test - Failed to commit transaction: Unexpected internal exception

Hi I'm trying to create a simple producer-consumer queue scenario but am getting the followin exception: ... this works ok. Obviously the runtime is longer due to the second insert/remove but it runs at a relatively consistent pace and completes ... only when running the ordered query and writing to the second database. Again, I'm not sure if this is a problem with the ...

 
forum_thread

slow performance for a complex query

Hi, We have a query that is constructed dynamically, an example is like this: SELECT DISTINCT $1 FROM CDI $1, Organisation $2, Organisation $3 WHERE ((UPPER($1.cdiId) LIKE 'THREAD14%') AND ((($1.parentOrgId='news') OR (($1.parentOrgId=$2.organisationId) AND ($2.parentOrgId='news'))) OR ((($1.parentOrgId=$3.organisationId) AND ($3.parentOrgId=$2.organisationId)) AND ($2.parentOrgId='news')))) I've also tried running the CDI query first and passing the results into the organisation query as follows: ... the results of the first query as a parameter to the second query. ObjectDB Support ObjectDB - Fast ...

 
release

2.3.1

... ( YEAR , MONTH , DAY , HOUR , MINUTE , SECOND ). Added support of  bypassing no arg ...

 
manual

Database Doctor

Explains how to use the ObjectDB object database Doctor tool to diagnose and repair database files and damaged Java/JPA/JDO objects.... path to the original (corrupted) database file. The second argument ( new.odb above) is the path to the new database file to be ...

 
forum_thread

ID format in objectdb 2.x for JDOHelper.getObjectId

Hi, I am trying to upgrade the objectdb from 1.x to 2.x. I installed and configured as per object db tuotrial. I am just wondering, in objectdb 1.x, when i am tring to get the object id for a persistable object, i am getting an integer as a result e.g Object obj = JDOHelper.getObjectId(logTestRunImpl) used to return suppose 1 obj.toString() = 1 but the same code when i am trying to execute for the same object in object db 2.x, i am getting ... You are right, actually the first solution depends on the second solution, i.e. you have to add an ID field anyway: @ ...

 
forum_thread

Database is locked when in use

I am oberving that when i reading anything from odbfiles, i am not allowed to copy and paste the odb files in the file system but the same i was able to do it in object db 1.0. We supprt export functionality and if i am not allowed to copy it in objectdb 2.x, then its a problem for us :-( Do you have any settings or other way to handle this? ... "your-dir-name"); Is the second agruement a string <Dir Absolute path> or new File (diectory ...

 
forum_thread

UserException - Object User#2 belongs to another EntityManager

Hi! Scenario's steps: 1. User goes to his profile, a JSF page. 2. @RequestScoped CDI bean UserDataB loads the current user of the session at each request, by using @Stateless bean UserC#findUserById(Long id) 3. JSF page's @RequestScoped CDI bean AnotherB loads trades of that user, by using @Stateless bean TradesC#findTradeByClient(User u). ### UserC and TradesC have their own @PersistenceContext EntityManager with the same unitName. ... Well, the thing is that EM should be closed when the second @Stateless executes the method, so the User entity shouldn't be ...

 
forum_thread

Slow searching with two indexes

I'm running queries on a large database (tens of millions of objects), and I'm running into a performance problem using two indexes.  An entity I'm querying has two indexed fields - one is the primary key (id) and so is different for each object, and the other is an object reference that only has a few tens of different values.   When I query by just the primary key, it's (of course) extremely fast, but when I also query using the other key, queries can take minutes.... 2016-11-17 07:48 The second query is slow because of the need to retrieve timeReceived value for ...

 
forum_thread

exception during online backup

hi   from time to time i get exception during online backup in server/client config: ... test. In first step provisioning is executed and in a second online backup and as I said, sometimes it works sometimes no br ...