Operating system: Temporary testing is under window and deployed under linux.
Disk format: NTFS
Database requirements: Since sqlite does not support partitioning, it is necessary to build 20,000 tables and insert 86,400 data into each table, so it will not take time to modify a record in 20,000 tables. This is a limit case, and normal use means that there is no 5s to modify 20,000 tables at the same time.
By the way, can sqlite have only one write connection at the same time? Is there any way to make it write multiple connections at the same time?