I am trying to do key value pairing, where performance is the top priority. I understand that the smaller a sqlite file is, the better the read and write speeds are, and so I am going to create about 64 files, having every explicit key-value combination.
Hence I would like to create a command that will create a new table inside its own file. How do I do this?
Thanks.