How to get many documents from RethinkDB by array of ids?

Question

I have array of ids

ids = [1, 2, 3, 4, ...] #1000 ids

How I can use this function:

r.table("users").get_all(1, 2, 3, 4, ..1000 ids.., index: "id")

I can use

r.table("users").filter{ |doc| r.expr(ids).contains(doc["id"])}

But it is too slow on DB with 6 mln docs

How I can pass array to arguments? – Alexander Nikolaev Mar 20 '18 at 17:17 — Alexander Nikolaev, Mar 20 '18 at 17:17

score 2 · Accepted Answer · answered Mar 20 '18 at 17:21

2

To expand your ids array into a list of arguments (that is expected by the get_all method) use the splat operator (*array) like this:

ids = [1, 2, 3, 4]
r.table('users').get_all(*ids, index: 'id') # note the `*`

answered Mar 20 '18 at 17:21

spickermann

Thank you for help – Alexander Nikolaev Mar 20 '18 at 17:41
I aceepted this answer, but I can't vote, because I have low rating – Alexander Nikolaev Mar 20 '18 at 19:17

1 Answers1