Hibernate@OneToOne@JoinColumns注释加载速度

Question

我试图使用Spring数据JPA注释在这两个实体之间创建关联。

这是我的第一个实体：演员

@Entity
@IdClass(SharedPrimaryKey.class)
@Data
@AllArgsConstructor
@NoArgsConstructor
@EqualsAndHashCode
@Table(name = "ACTOR")
public class Actor implements Serializable {
    @Id
    @Column(name = "ACTOR_NAME")
    private String actorName;

    @Id
    @Column(name = "ACTOR_DOB")
    private String actorDob;

    @OneToOne(fetch = FetchType.LAZY)
    @JoinColumns({
            @JoinColumn(name="ACTOR_NAME"),
            @JoinColumn(name="ACTOR_DOB")
    })
    private Movie movie;
}

这是我的第二个实体：电影

@Entity
@IdClass(SharedPrimaryKey.class)
@Data
@AllArgsConstructor
@NoArgsConstructor
@EqualsAndHashCode
@Table(name = "MOVIE")
public class Movie implements Serializable {
    @Id
    @Column(name = "ACTOR_NAME")
    private String actorName;

    @Id
    @Column(name = "ACTOR_DOB")
    private String actorDob;

    @Column(name = "MOVIE_TITLE")
    private String movieTitle;
}

我面临的问题是，当我试图根据演员名称检索所有电影时，@OneToOne和@JoinClons功能花费的时间太长。我以前将此设置为@OneTo许多，速度快得多，但由于两个表都使用复合主键，因此需要进行此更改。我可以使用哪些注释来加速此查询？

Answer 1

"我试图根据演员名称检索所有电影"它看不到与我的OneToOne关系。更多的是ManyTo许多一。忘记复合id-s。它们没有好处。Lombok@Data注释是许多注释的包装器。如果表名等于实体名称，则不需要@Table。

@Entity
@Data
public class Actor implements Serializable {
  @Id
  @GeneratedValue(strategy = GenerationType.AUTO)
  @Column(name = "ACTOR_ID")
  private String actorId;

  @Column(name = "ACTOR_NAME")
  private String actorName;

  @ManyToMany
  @JoinTable(
  name = "ACTOR_MOVIE", 
  joinColumns = @JoinColumn(name = "actorID", referencedColumnName = "actorID" ), 
  inverseJoinColumns = @JoinColumn(name = "movieID", referencedColumnName = "movieID"))
  private List<Movie> movies = new TArrayList<>();
}

@Entity
@Data
public class Movie implements Serializable {
  @Id
  @GeneratedValue(strategy = GenerationType.AUTO)
  @Column(name = "MOVIE_ID")
  private String movieID;

  @Column(name = "MOVIE_TITLE")
  private String movieTitle;

  @ManyToMany
  private List<Actor> actors = new TArrayList<>();
}