How to create multiple indexes at once in RethinkDB?

Question

In RethinkDB, is it possible to create multiple indexes at once?
Something like (which doesn't work):

r.db('test').table('user').indexCreate('name').indexCreate('email').run(conn, callback)

Joe Doliner · Accepted Answer · 2013-10-03 08:09:56Z

1

Index creation is a fairly heavyweight operation because it requires scanning the existing documents to bring the index up to date. It's theoretically possible to allow creation of 2 indexes at the same time such that they both perform this process in parallel and halve the work We don't support that right now though.

However I suspect that's not what you're asking about. If you're just looking for a way to not have to wait for the index to complete and then come back and start the next one the best way would be to do:

table.index_create("foo").run(noreply=True)
# returns immediately
table.index_create("bar").run(noreply=True)
# returns immediately

You also can always do any number of writes in a single query by putting them in an array like so:

r.expr([table.index_create("foo"), table.index_create("bar")]).run()

I can't actually think of why this would be useful for index creation because index writes don't block until the index is ready but hey who knows. It's definitely useful in table creation.

answered Oct 3, 2013 at 8:09

Joe Doliner

2,2502 gold badges16 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Robert Zaremba Over a year ago

Thanks, As you expected, I'm going to use them in table creation.

Collectives™ on Stack Overflow

How to create multiple indexes at once in RethinkDB?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related