I have exactly same indexes. Do you see created indexes in H2 console under corresponding tables?
2016-05-27 16:39 GMT+03:00 jan.swaelens <[email protected]>: > Okey so we can indeed conclude that the indexes are not registered. This is > the output: > > /SELECT > ACTIVITY0.ACTIVITY_ID, > ACTIVITYUSERACCOUNTROLE0.ACTIVITY_ID > FROM "Activity".ACTIVITY ACTIVITY0 > /* "Activity".ACTIVITY.__SCAN_ */ > LEFT OUTER JOIN "Activity".ACTIVITYUSERACCOUNTROLE ACTIVITYUSERACCOUNTROLE0 > /* "Activity".ACTIVITYUSERACCOUNTROLE.__SCAN_ */ > ON ACTIVITY0.ACTIVITY_ID = ACTIVITYUSERACCOUNTROLE0.ACTIVITY_ID > (1 row, 5 ms)/ > > So lets take a step back, in the 'Activityuseraccountrole' I have this: > > / /** Value for activityId. */ > @QuerySqlField(orderedGroups={@QuerySqlField.Group(name = > "Activityuseraccountrole_idx", order = 0)}) > private long activityId; > > /** Value for useraccountroleId. */ > @QuerySqlField(orderedGroups={@QuerySqlField.Group(name = > "Activityuseraccountrole_idx", order = 1)}) > private long useraccountroleId;/ > > in the 'Activity' I have this: > > / @QuerySqlField(orderedGroups={@QuerySqlField.Group(name = > "Activity_idx", order = 0)}) > private long activityId; > > /** Value for realizationId. */ > @QuerySqlField(orderedGroups={@QuerySqlField.Group(name = > "Activity_cond_idx", order = 1)}) > private Long realizationId; > > /** Value for kernelId. */ > @QuerySqlField(orderedGroups={@QuerySqlField.Group(name = > "Activity_cond_idx", order = 0)}) > private Long kernelId; > > /** Value for removefromworklist. */ > @QuerySqlField(orderedGroups={@QuerySqlField.Group(name = > "Activity_cond_idx", order = 2)}) > private boolean removefromworklist;/ > > Does this match with what you have sent me? > > If so, maybe they are not applied by how I load up the cache? > > I have this code: > > /CacheConfiguration<ActivityKey, Activity> activityCacheCfg = > CacheConfig.cache("Activity", new SofIgniteDSStoreFactory<ActivityKey, > Activity>()); > cfg.setCacheConfiguration(activityCacheCfg); > / > > The CacheConfig also defines the fields ... and not the indexes we add from > annotations - is this potentially clashing? > > best regards > jan > > > > -- > View this message in context: > http://apache-ignite-users.70518.x6.nabble.com/Unexpected-performance-issue-with-SQL-query-followed-by-error-tp4726p5281.html > Sent from the Apache Ignite Users mailing list archive at Nabble.com. > -- Best regards, Alexei Scherbakov
