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.
