erquhartE
Convex Community3y ago
33 replies
erquhart

Making migrations faster

Migrations are probably my biggest pain point right now. Any patch operation against a table has to be done on 200 records per page, and each page takes ~30s. This seems orders of magnitude slower than it should be, so I'm pretty sure I'm doing something wrong.

I was originally using the helper from your repo, but thought I'd try just writing a plain action that uses a paginated mutation so I don't have to manually page through and keep passing the cursor in myself (which the helper requires).

I'm now trying to patch records concurrently, say in chunks of 20, but this seems to break convex and the instance stops responding for a while before what I can only assume is a reboot of some sort.

So I guess the questions are:
1. are concurrent write operations supported?
2. are migrations supposed to take this long or am I holding it wrong?
Was this page helpful?