Kedric Kim

자체 해결하여 남깁니다 ! CachedNetworkImage의 memCacheHeight를 grid 크기에 맞게 선언하여 해결하였습니다감사합니다

CachedNetworkImage 로 인한 memory leak 문제..

안녕하세요
우선 영한님의 강의를 토대로
&nbsp;from절에서의 subquery는 안된다는 전제하에
쿼리를 2번 나눠서 실행하였습니다.
(참고로 mysql 기준입니다.)
혹시 다른 방법이 있다면 답변 부탁드립니다
&nbsp;
- 기존소스
<pre style="box-sizing: border-box; margin-top: 0px; margin-bottom: 16px; padding: 16px; -webkit-font-smoothing: auto; font-family: Menlo; background-color: #2b2b2b; color: #a9b7c6; font-size: 15pt; overflow: auto; overflow-wrap: normal; line-height: 1.45; border-radius: 3px;">@Test public void updateSubquery() { Team team = new Team("teamA"); em.persist(team); Member newMember = new Member("user1"); newMember.setTeam(team); em.persist(newMember); QMember subM = new QMember("subM"); QTeam subT = new QTeam("subT"); long result = queryFactory .update(member) .set(member.age, member.age.add(10)) .where(member.id.in( JPAExpressions.select(subM.id) .from(subM) .join(subM.team, subT) .where(subT.name.eq("teamA")) )) .execute(); assertThat(result).isEqualTo(1); }</pre>
&nbsp;
- 수정한 소스
<pre style="box-sizing: border-box; margin-top: 0px; margin-bottom: 16px; padding-top: 16px; padding-right: 16px; padding-bottom: 16px; -webkit-font-smoothing: auto; font-family: Menlo; background-color: #2b2b2b; color: #a9b7c6; font-size: 15pt; overflow: auto; overflow-wrap: normal; line-height: 1.45; border-radius: 3px;">@Test public void updateSubquery() { Team team = new Team("teamA"); em.persist(team); Member newMember = new Member("user1"); newMember.setTeam(team); em.persist(newMember); QMember subM = new QMember("subM"); QTeam subT = new QTeam("subT"); List<Integer> list = queryFactory .select(subM.id) .from(subM) .join(subM.team, subT) .where(subT.name.eq("teamA")) )).fetch(); long result = queryFactory .update(member) .set(member.age, member.age.add(10)) .where(member.id.in( list )) .execute(); assertThat(result).isEqualTo(1); }</pre>

Kedric Kim

投稿