Hello, Is there any way to estimate the size of the metadata of a SQLite database?
I am trying to do the following: 1) Set the DB size using MAX_PAGE_COUNT and PAGE_SIZE parameters 2) I want to do a bulk insert. 3) However, I want to insert only those many records such that the insert succeeds. 4) I also want to keep a 30% buffer for the data. I would like to start new DB instances when that threshold is reached. To do step 3 successfully, I have to estimate the size of the meta-data. Assuming that there is no more data model changes, is there a algorithm or heuristic to determine the amount of meta data present in the database? Thanks and Regards, Yuva