Coverting 305GB CSV to sqlite database
Any advice for how to do this faster? I created the database and am using .import but it's obviously taking a very long time.
See if the limiting factor is CPU, DASD (I/O), or RAM. Once you have identified the bottleneck, then go to the bank and get some money so you can go to the store and buy a bottle (CPU/DASD/memory) that has a bigger neck to replace the bottle with the small neck.
You have provided no information which could be used to generate any other process improvement.
I would test it with the top 100 lines first. Apart from that, you seem to know what you're doing.