SQLite Forum

how to pre allocate my SQLite database to a certain size
Login

how to pre allocate my SQLite database to a certain size

(1) By researchstudent2021 on 2021-04-08 21:58:13 [source]

Is there a way to pre allocate my SQLite database to a certain size? If yes, can you give me an example of how to? Thanks in advance

(2) By anonymous on 2021-04-09 01:01:33 in reply to 1 [link] [source]

    create table filler (fill blob);
    insert into filler values(zeroblob(2000000));
    drop table filler;