dongsui4658
2017-02-17 06:43
浏览 324

SQLX WHERE IN查询长列表

I'm using sqlx to perform a query in my Go code. The query has a long list of values (~10,000) that I need to filter on in the WHERE IN (?) clause. This causes a huge slowdown in performance. How can I optimize such a query? Also, this query is being performed on a Redshift cluster, so indexing a column isn't a solution to improve the query performance.

values := []int64{143, 123, 123, 542....} // ~10,000 elements
query, args, err := sqlx.In(query, values)
if err != nil {
    return nil, err
}

query = dbInterface.Rebind(query)   
err = dbInterface.Select(&list, query, args...)

Query:

SELECT * FROM table_name WHERE some_id IN (?) ORDER BY created_at;
  • 写回答
  • 好问题 提建议
  • 追加酬金
  • 关注问题
  • 收藏
  • 邀请回答

2条回答 默认 最新

  • dtrpv60860 2017-02-20 06:31
    已采纳

    I ultimately created a TEMP TABLE for the ids and performed a JOIN. This greatly improved the query performance.

    评论
    解决 无用
    打赏 举报
查看更多回答(1条)

相关推荐 更多相似问题