Apache Ignite Quick Start Guide

Non-collocated

Non-collocated SQL joins can create performance issues. We no longer need to use affinity keys to collocate the entries. In this section, we are going populate the player and club caches and use distributed SQL joins. The following are the steps:

1. Create a class, SQLQueryNonCollocatedTest:

     public class SQLQueryNonCollocatedTest {     private static final String CLUB_SQL_CACHE = "club_sql_cache";     private static final String PLAYER_SQL_CACHE = "player_sql_cache";     public static void main(String[] args) {     IgniteConfiguration cfg = new IgniteConfiguration();     cfg.setClientMode(true);     cfg.setPeerClassLoadingEnabled(true);

2. Create the player config with—key = player id and value= player:

      CacheConfiguration<Long, SoccerPlayer> playerCacheConfig ...