Hello together,
i am writing a small programm that parses csv, xlsx or ods files, creates db tables for them and seeds them into the tables.
The Problem i am facing atm is that it takes very long for roo to parse the spreadsheet and create the object. Is there a silver bullet how to do this for large input files?
Does it make sense to split the files beforehand or is there a format that renders roo to be significantly faster concerning the parsing? How would you do that?
Thanks in advance
Martin