Accelerate CSV import time
Closed this issue · 0 comments
kyoshizaki commented
Check the time to import CSV
Data size in verification CSV files
- academicSessions: 5
- classes: about 3,800
- courses: about 19,900
- enrollments: about 97,600
- orgs: 1
- users: about 6,400
Import time result
- Without model associations: about 2'25
- With model associations: about 13'40
- With bulk insert: about 0'51
Conclusion
- Use 'bulk insert' with activerecord-import gem for massive CSV files.