Reputation: 11
There’s a CSV file with 2mil records.
I iterate line by line and schedule a sidekick worker for each CSV row. The worker finds the corresponding record in the db with searchkick and creates a new record based on the search result.
Is there any way to bulk update created records with the info from the search in one go or any other approach to speed up the process?
I have tried creating new records one by one using the search results info. Having 2 mil records will take almost 24 hours if not longer for background jobs to finish.
Upvotes: 0
Views: 32