20 | query hint)) [[objectdb.query-plan-text=index(ctso['(TC)'->'(TC)']] but the index that is in the hint is not used the MultiVarPlan that is listed shows our index in a filterPlan: <filterPlan 2.0848 0,56/0,00 (v$1 ... (o) instances ---------------------------------------- [Step 1a] Scan index com.agile.hummingbird |
20 | ODB IndexActivation NullPointerExceptionHi, We have created indexes on an existing database, which has 4.3 million objects. As soon ... ) * Batch ended at 88 I've read that: "Indexing large amount of data may take considerable processing time." Do we have to wait until index activation is finished before we can start using the database or |
19 | Mysterious "Attempt to persist a reference to a non managed instance" error, but it's still failing. It involves two entities, Index and Ostrich. The thing to note is that the Index structure is recursive through maps; but that's never caused any problem for me in the past ... .CascadeType.*; import static javax.persistence.FetchType.*; @Entity public class Index implements |
18 | Performance issue in a query due to compareTo calls (AccessType.FIELD) public class TCStep extends Identifiable { @Index private long stepNumber ... , cascade = CascadeType.REMOVE) private Values valuesRef; } @Index (members = {"step.stepNumber"}) @Entity @Access (AccessType.FIELD) public class Values extends Identifiable { @Index |
18 | First query takes 4+ minutes to complete({ : // Indices building trees in client applications @Index(members={"startDate", "toExtension"}), @Index(members={"startDate", "fromExtension"}) }) public class ... Please try adding an index: @Index(members={"startDate", "startTime", "channelNumber"}) Start |
18 | significant performance decrease, what can we do ? hgzwicker Hans-Georg Zwicker More information is needed. Are you using indexes? Queries become slower with larger databases if indexes are not defined, or not defined properly. Please provide more details about the query, relevant entity classes, indexes, database size, and query |
18 | Left join fetch behaviour doesn't retrieve children? on an attribute which is also indexed we may have some weird behaviour. Sometime (a broken index ... if my index has been broken ( may i have some indications to test that ? ) or if that behaviour happen also on right indexes. In my short test case with index on left joined attribute, i haven't succeed |
17 | Exception on creation when running multithreaded.compiler] <finalPlans> <fatchPlan plan="fetch(index(-101[all]))" eval="5.1439" var="1" prm="0" reg="0"> <btreePlan plan="index(-101[all])" eval="3.8429" var="1" prm="0" reg="0 ... " /> </extractPlan> </filterPlan> <fatchPlan plan="fetch(index(-107[pos<1>:1->:1:notNull |
17 | Efficient query on EmbeddedId.field1 and entity.id.field2 form a composite index together, in the order in which they were declared. In this case, can I just declare an additional index on entitiy.id.field2 in the entity class as @Indices({@Index(members = {"id.field2"})}) or do I have to duplicate entity.id.field2 into entity |
3 | queries under 2.7.6_4 significantly slower than under 2.7.6 1: Process ObjectNode (o) instances ---------------------------------------- [Step 1a] Scan index ... ,index(-104['(OP)'->'(OP)':notNull])) <x> v$1:filter(extract(v$1,type(ObjectNode[set])),or(and((v$1 ... ='plannedState'))))" eval="15.1373"> <multiVarPlan plan="o:extract(o,index(-104['(OP)'->'(OP)':notNull |
